LinkBack URL
About LinkBacks
How TAB names be created automatically by reference to words in the spreadsheet?
How TAB names be created automatically by reference to words in the spreadsheet?
Sheets("Sheet1").Name = Sheets("Sheet1").Range("A1").Value
Change sheet and range to suit.
Regards, TMS
Last edited by TMS; 09-12-2012 at 12:11 PM. Reason: Add missing quote
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks TMS, but unfortunately I don't know how to use the information you've provided. Is the any explanation.
You would have to create a short macro containing an edited version of that line of code. Or a variation on it.
If you can be more specific about what you want to happen, I can perhaps offer a generic solution.
Regards, TMS
Let's say that in cell A1 I have the word "Corporate" and I want the TAB name to be "Corporate".
Thanks again.
I got this to work, but it's not quite what I wanted. I tried to re-write it using ActiveSheet, but I couldn't get it to work. Should I be able to use "ActiveSheet"?
Works for me:
Please Login or Register to view this content.
Regards, TMS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks