REname tabs macro, error
I am trying to copy tabs and change the names. However the tabs I'm trying to copy may change names and this is causing my macro to fail.
Basically I would like to always copy the 5th and 6th tab along and change their names to, lets say "TAB-A" and "TAB-B" no matter what their currently called.
Does anyone know how to do it as i can only get it to refer to the actual tab name and not the positioning of the tab.
cheers
not sure what your macro does, but every sheet has an indexnumber based on where they're at.
if you want to copy sheets five and six, then
for example?
Please Login or Register to view this content.
Last edited by wamp; 04-27-2010 at 12:37 PM.
Perhaps there is more to your post than you describe, but give this a try.
Please Login or Register to view this content.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks