Rename Sheet from a cell value

G

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

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.
 
G

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

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

Claus Busch

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top