I assume that you are using the Sheet4 which is what you see in the VBE
project explorer. ... Sheet4(MyTabName) Change that lise of code to read

Set wks = Sheet4 'This should fix it.

Changing the column was correct. Leave the last line at A2. This is where
the rows will be pasted A2 through A???
--
HTH...

Jim Thomlinson


"Rekanix" wrote:


Hey, Jim

I did what you said (Cool! I'm into a whole new dimension of Excel
here that I didn't know even existed!). I ran the macro and got the
following error: Run time error '9', Subscript out of range. I
clicked "Debug", and it highlights and points out this line in the
code: Set wks = Sheets("Sheet4") 'Change This

I changed the "Sheet 1" to "Sheet 4", because that's what it is in my
budget. I also changed the column from F to E, and I changed the range
from A2 to B3:L150 (I'm assuming this covers all of my table). Is this
correct?

Thanks for your help!
Robert


--
Rekanix
------------------------------------------------------------------------
Rekanix's Profile: http://www.excelforum.com/member.php...o&userid=29586
View this thread: http://www.excelforum.com/showthread...hreadid=492857