View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lenny Lenny is offline
external usenet poster
 
Posts: 37
Default creating a sheet 1 of

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