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

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

Lenny wrote:
Don: my thanks for taking the time to respond, however, what do I do with
the information you provided below? Is it a formula? Where does it get
added (what cell(s)) and to which sheets in a multi sheet workbook? I
assume(?) that once placed on any of the worksheets, it will move when a
worksheet is copied?

Sorry - but this is real newbie territory for me. Things just don't seem to
work the way they do in Word tables..... regards

"Don Guillett" wrote:

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

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Lenny" wrote in message
...
Lenny wrote:
Don: my thanks for taking the time to respond, however, what do I do with
the information you provided below? Is it a formula? Where does it get
added (what cell(s)) and to which sheets in a multi sheet workbook? I
assume(?) that once placed on any of the worksheets, it will move when a
worksheet is copied?

Sorry - but this is real newbie territory for me. Things just don't seem
to
work the way they do in Word tables..... regards

"Don Guillett" wrote:

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