How can I get the number of pages in the worksheet, not the workbook?

Hi there, I need to put "Page X of Y" on my worksheets but I can't get the "Y" right. I need "Y" to be the number of pages on each worksheet, not the workbook. Every workbook is a set of related, but separate legal documents. We frequently need to print the entire workbook at once. Of course, Excel insists on counting all the pages in the workbook.

My other, related concern is how robust Excel macros are, and if macros will even work for me. I've only used macros a couple times in the past and found that the more a file is used, the buggier the macro gets. I'm tasked with creating new-and-improved templates that will be used by about a hundred different people to create many thousands of these workbooks over time. So my templates get copied, and then the data in each workbook will be revised more than once before people are done with it.

Thanks a bunch!
Tara

Found this on a search. It might be what you are looking for.

Please Login or Register  to view this content.