Renaming Active Worksheet

[Guest]

I have no coding experience, but I find myself frequently needing to take a cell value from the active workbook and use it as the sheet name. What do I need to do to create a macro that will work every time I need to rename a new sheet. Thanks for any help

tj

 

[Bob Phillips]

Sub RenameSheet
Activesheet.Name = Activecell.Value
End Sub

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

I have no coding experience, but I find myself frequently needing to take

a cell value from the active workbook and use it as the sheet name. What do
I need to do to create a macro that will work every time I need to rename a
new sheet. Thanks for any help!

 

[Guest]

Thank you!