If anybody would be willing to help, again, what I'd like to have done is to have a blank column inserted between columns W and X(these values change so the VBA statement should reference the end of the columns) and the values that are now in column Y(April 17th values) pasted as values into the now empty column X. I would like to do this for tabs Ann-Sheet 2. I'm having a bit of trouble with setting up the loop that would go through the desired sheets.
Last edited by eonizuka; 05-05-2009 at 06:30 PM.
Create a name "Last_Column", refers to: "Ann!X3" for each sheet
Note: Make sure you put the "Ann!" in front of name and the same for every worksheet.
Then your macro could be
Please Login or Register to view this content.
I'm receiving a 400 error when I attempt to run the code. I have created a named range and referred it to the X3 cell in each sheet. Should I use the name Ann for each sheet or the name of the sheet? Thank you for your help Foxguy. I do appreciate it.
Last edited by eonizuka; 04-21-2009 at 06:49 PM.
No don't use Ann for each sheet. Use the Sheet's name.
Ann!Last_Column on Ann's sheet
Ben!Last_Column on Ben's sheet
etc.
What line produces the 400 error?
Oh OK, I'll give that a try.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks