Hi,

Am Tue, 26 Nov 2013 09:30:11 -0800 (PST) schrieb Garry:

1) Is it possible via a macro To take the value of say Cell (A1) and rename the current sheet you have focus on.

try:
ActiveSheet.Name = Range("A1")


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2