Apparently you don't understand the code.

The activesheet is used to look for the word BANK, so if you don't want the
value in column F next to BANK pasted in cell AL2 of that same sheet, you
will have to specify where you do want it pasted - activesheet won't cut it
here.

--
Regards,
Tom Ogilvy

"alexm999 " wrote in message
...
OK, im almost there...
My worksheets will change on a monthly basis...

Instead of sheet101 as the worksheet. How do I make it point to
"activeworksheet" so it doesnt matter what i call the worksheet next
month...?


---
Message posted from http://www.ExcelForum.com/