Rename current sheet

G

Guest

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"
 
B

Bob Phillips

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)
 
R

Ron de Bruin

Hi ?

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