print page totals in every page automatically

[asokaw]

I need to calculate & print page totals automatically in every page at the bottom

[Pepe Le Mokko]

Insert footer and select "number of pages" in the footer tool

[aydeegee]

Hi asokaw

With the greatest of respects to Pepe, I believe you are asking for the page total of the data, rather than the total number of pages.

Because of the different printer and page settings, I think that this has to be done by VBA, so here is an example. Please read the instructions first, try it, and let me know if this does what you require.

To see the code press Ctrl + F8.


Regards
Alastair