Worksheet name

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

I have a macro that I am hoping to add a little to. I
would like to know if it is possible to change the
worksheet name to reflect what is in a certain cell (B2)

tia
 
Brian,

You can use something like

Worksheets(1).Name = Worksheets(1).Range("B2").Value

Or,

Sheet1.Name = Sheet1.Range("A1").Value
 
Back
Top