On Tuesday, 26 November 2013 17:41:42 UTC, Claus Busch wrote:
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

Im sorry, Could you please tell me where this goes in the sheet. Sorry Im a bit thick.
Garry