Thread: Tab Names
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default Tab Names

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