MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Macro to rename sheet as a cell value


Posted by Susan Aspland on November 01, 2001 5:45 AM

Is it possible to have a macro that will rename a sheet as a cell value?
eg: activesheet.name = (value of d1)

Please help a dumb blonde.


Posted by Chris on November 01, 2001 5:49 AM

try this

activesheet.name = Range("a1").value

Posted by Susan on November 01, 2001 5:58 AM

Your a charm Chris

That did the trick