TAB Naming

[rbleck]

How TAB names be created automatically by reference to words in the spreadsheet?

[TMS]

Sheets("Sheet1").Name = Sheets("Sheet1").Range("A1").Value


Change sheet and range to suit.


Regards, TMS

[rbleck]

Thanks TMS, but unfortunately I don't know how to use the information you've provided. Is the any explanation.

[TMS]

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

[rbleck]

Let's say that in cell A1 I have the word "Corporate" and I want the TAB name to be "Corporate".

Thanks again.

[rbleck]

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"?

[TMS]

Works for me:

Please Login or Register  to view this content.

Regards, TMS