In a worksheet called "Lookups", I have a list of existing worksheet names in cells S12:S110.
In cells T12:T110, I have a corresponding list of what I would like to *change* those worksheet names to, a "desired worksheet names list" if you will.
Given that this would require ~100 manual worksheet name adjustments, I am trying to figure out a VBA solution to this. Does anybody know how to do this. It seems so straightforward.
Thanks!
Try the below code..........
Please Login or Register to view this content.
Last edited by JBeaucaire; 02-18-2013 at 12:13 AM. Reason: Corrected ranges to OP's actual ranges.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Fantastic. Thank you!!
Glad it helps you and thanks for the feedback and rep
Thanks to JBeaucaire for correcting the Ranges to suit OP's requirement
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks