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: = (value of d1)

Please help a dumb blonde.

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

try this = Range("a1").value

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

Your a charm Chris

That did the trick