renaming the active sheet
 

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

renaming the active sheet
 

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" wrote in message
...
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