Renaming Active Worksheet

T

tjtjjtjt

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
 
B

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)

tjtjjtjt said:
I have no coding experience, but I find myself frequently needing to take
Click to expand...
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!
 
Top