Automatic Sheet Numbering

[stephenkollen]

I have a report blank that is comprised of numerous excel worksheets (fixed letter size). During the completion of the report, one may add, delete, and/or move worksheets. I want each worksheet to have a cell that dispalys 'page # of total number of sheets'. Is there a way to automatically update this information?

[JBeaucaire]

If there is a cell that ALWAYS has something in it on every sheet, like A1, this would work to count sheets:

Please Login or Register  to view this content.

[stephenkollen]

thank you.

I am a bit of a novice and was wondering if someone could let me know how to get the sheet index number so that I can assign it as 'page of page count'?

[Leith Ross]

Hello stephenkollen,

When you refer to the sheet index number are you referring to the the creation order of the sheet or the code name e.g. Sheet1, Sheet2?

Sincerely,
Leith Ross

[stephenkollen]

Thanks for all the help. I came up with the follwing code that works OK.

Please Login or Register  to view this content.