Tab Names-Is it possible to set the tab names equal to a cell?

[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"
<[email protected]> wrote
in message
news:[email protected]...
>
> Is it possible to set the tab (worksheet) names equal to a
> cell?
>
>
> --
> higherlimits
> ------------------------------------------------------------------------
> higherlimits's Profile:
> http://www.excelforum.com/member.php...o&userid=34841
> View this thread:
> http://www.excelforum.com/showthread...hreadid=545891
>

[Gary''s Student]

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


--
Gary''s Student


"higherlimits" wrote:

>
> Is it possible to set the tab (worksheet) names equal to a cell?
>
>
> --
> higherlimits
> ------------------------------------------------------------------------
> higherlimits's Profile: http://www.excelforum.com/member.php...o&userid=34841
> View this thread: http://www.excelforum.com/showthread...hreadid=545891
>
>