numbering new sheets with the same number
 

Hi

i need to know how to number new sheets with the same
number as previous ones

can anyone help

thanx
NICK

numbering new sheets with the same number
 

Nick,

I'm not sure what you mean. You can change the name of a sheet with code
like

Worksheets(2).Name = "NewName"

Perhaps you could provide a few more details about what you want to do.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"NICK" wrote in message
...
Hi

i need to know how to number new sheets with the same
number as previous ones

can anyone help

thanx
NICK

numbering new sheets with the same number
 

...is not possible as you cannot have sheets with same number or name.

Tom