Tab Names

[higherlimits]

Is it possible to set the tab (worksheet) names equal to a cell?

 

[Chip Pearson]

Only with VBA code.


Sub AAA()
Worksheets(1).Name = Worksheets(1).Range("A1").Value
End Sub



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"higherlimits"
in message
news:[email protected]...

 

[Guest]

Yes, but:

1. the cell must contain a legal tab name
2. tab names must be unique

Sub Macro2()
Sheets("Sheet1").Select
Sheets("Sheet1").Name = Cells(1, 1).Value
End Sub