Get total pages per sheet and set page numbers in page footer by formula

[Snoopy2003]

Hello,

I have two sheets that I publish together as pdf.
I set page breaks in my second sheet by VBA,
so I have different total pages every time.

I wish to have '1 of 5' page numbering on both sheets.

How can I set page numbers in sheets footer by a formula that will sum number of pages of both sheets ?

Thank you for your help

[Deann]

Edit:
I'm sorry I did not read the startpost correctly and see that my solution does not give an answer to your question




I'm quite new here, but I seem to know the answer to this question, a better start than asking one I guess?

Please Login or Register  to view this content.

The &P part states the current page number
The &N part states the total number of pages

I hope it helps!

[Snoopy2003]

Hello,

Thank you for trying to help.

[Snoopy2003]

Hello,

Can I add a cell value to page footer ?
Can I write a formula to retrieve sheet &N value ?

Thank you for your help