View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John[_122_] John[_122_] is offline
external usenet poster
 
Posts: 19
Default How do I make a worksheet name equal to a cell

Sheets(3).Name = Sheets(3).Cells(1,1).Value

This will set the name of the third sheet to whatever is in cell of
that sheet. Adjust as needed.

tim m wrote:
I have an existing workbook with several worksheets. I need to make the
worksheet name equal to a cell in the worksheet