Worksheet name

P

Patol

Hi! can anyone tell me how to make the worksheet tab name equals to a
certain cell content, please?
Thanks!
 
M

Mark

Try this:

Sub AutoNameSheet()

Application.ActiveSheet.Name = Application.ActiveCell

End Sub

just select the cell that has the name you want your sheet to have and
then run this macro.
 
M

Mark

Try this:

Sub AutoNameSheet()

Application.ActiveSheet.Name = Application.ActiveCell

End Sub

just select the cell that has the name you want your sheet to have and
then run this macro.
 
Top