G Garry Nov 26, 2013 #1 1) Is it possible via a macro To take the value of say Cell (A1) and rename the current sheet you have focus on. Thanks 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. Thanks garry
C Claus Busch Nov 26, 2013 #2 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. Click to expand... try: ActiveSheet.Name = Range("A1") Regards Claus B.
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. Click to expand... try: ActiveSheet.Name = Range("A1") Regards Claus B.
G Garry Nov 26, 2013 #3 Hi, Am Tue, 26 Nov 2013 09:30:11 -0800 (PST) schrieb Garry: try: ActiveSheet.Name = Range("A1") Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 Click to expand... Im sorry, Could you please tell me where this goes in the sheet. Sorry Im a bit thick. Garry
Hi, Am Tue, 26 Nov 2013 09:30:11 -0800 (PST) schrieb Garry: try: ActiveSheet.Name = Range("A1") Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 Click to expand... Im sorry, Could you please tell me where this goes in the sheet. Sorry Im a bit thick. Garry
C Claus Busch Nov 26, 2013 #4 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. Click to expand... 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.
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. Click to expand... 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.
