numbering new sheets with the same number

N

NICK

Hi

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

can anyone help

thanx
NICK
 
C

Chip Pearson

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.
 
Top