something like
for i = 1 to 21
sheets(i).add
next

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Lenny" wrote in message
...
I am creating an excel form (2003). Because of the format, I cannot use
excels worksheet automatic numbering. I have set up two cells, side by
side
to hold the entries: SHEET | OF | is there a way that Excel can
automatically number the sheet and correctly enter the number of total
worksheets in the file?

This is a no brainer in Word, I would just use the pageno and numpages
fields but this is new for me using Excel.

An explanation or help is always greatly appreciated

Lenny