Naming a worksheet

[ab123456]

I have a project containing hidden worksheets, depending on the users action I need to copy and modify a hidden worksheet. Both the original and modified sheet need to remain hidden.

I have used the code
'Sheets("BlankData&quot.Copy Before:=Sheets(1)'
to copy the worksheet but i now wish to rename it

As the new sheet is hidden i cant use 'Activesheet' to refer to the new sheet. I have tried using Sheets(1) but again this only seems to refer to visible sheets.

Any ideas??

Thanks

 

[joerd]

You can refer to the new sheet as Sheets("BlankData (2)&quot, as in Sheets("BlankData (2)&quot.Name = "NewName"

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.