Worksheet name

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
 
C

Chip Pearson

Brian,

You can use something like

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

Or,

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