Rename Sheet from a cell value
Hi,
Am Tue, 26 Nov 2013 10:51:12 -0800 (PST) schrieb Garry:
Im sorry, Could you please tell me where this goes in the sheet.
Press Alt+F11, insert a standard module and paste the code into the code
window:
Sub Test()
ActiveSheet.Name = Range("A1")
End Sub
Back on your sheet you can run the nacro "Test" to name the sheet.
Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|