renaming the active sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
See reply in .misc.

--

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!
 
Back
Top