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