Rename current sheet
 

How do I rename the current sheet.

This is what I have, but if sheet1 has already been
renamed, it won't work. Thank you.

Sheets("Sheet1").Name = "Linefile"

Rename current sheet
 

Activesheet.Name = "Line"

But see your other question about naming as we add.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

wrote in message
...
How do I rename the current sheet.

This is what I have, but if sheet1 has already been
renamed, it won't work. Thank you.

Sheets("Sheet1").Name = "Linefile"

Rename current sheet
 

Hi ?

You can't have two sheets with the same name
See my answer in your other thread

--
Regards Ron de Bruin
http://www.rondebruin.nl


wrote in message ...
How do I rename the current sheet.

This is what I have, but if sheet1 has already been
renamed, it won't work. Thank you.

Sheets("Sheet1").Name = "Linefile"

Rename current sheet
 

activesheet.name = "test"

Regards

Trevor


wrote in message
...
How do I rename the current sheet.

This is what I have, but if sheet1 has already been
renamed, it won't work. Thank you.

Sheets("Sheet1").Name = "Linefile"