Then, there's always the option to use one of the default XL "already
constructed" footers, one of which will give you:
Page 1 of 1
<File> <PageSetUp> <Header / Footer> tab,
And under "Footer",
Expand the footer box to display default footers.
Just click on the one of your choice to have it *automatically* inserted in
your footer.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
Max said:
and then put*:: &[Page] of &[Pages]
Slight tweak to the above, to sync with your subject line ..:
put instead: Page &[Page] of &[Pages]
(an additional "Page " part placed in front)