I have a workbook with seven worksheets.
Each worksheet has one unique print area.
I have a macro that prints all these "pages" simultaneously.
When footers are all formatted "Page &[Page] of &[Pages]" it results in all pages numbered "Page 1 of 1".
When footers are all formatted "Page 1 of 7" it results in all pages numbered "Page 1 of 7".
How can I have the first page print "Page 1 of 7" , the second page print "Page 2 of 7" and so on.
How can I do that?
[I can perhaps name the tabs "Page 1 of 7" , etc. and then have the tab names printed in place of page numbers, but I would like to have some other way of determining the page number. (For user friendlyness.)]