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
