Naming a worksheet
Naming a worksheet
(OP)
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").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
I have used the code
'Sheets("BlankData").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





RE: Naming a worksheet
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.