How can I add page numbers to the center footer with a given format -such as
"Page X of Y"- when my footer has already text?

Thanks

Excel version?

If 2003, go to File > Page Setup > Header/Footer tab, click "Custom
Footer", click in the Center Section, click the end of your text and
press the [+] button (the second button from the left) then type " of
" and click the [++] button (the third button from the left).

Does that work, or did you want a programmatic solution?

--JP

On Oct 2, 2:43*pm, Jess <J...@discussions.microsoft.com> wrote:
> How can I add page numbers to the center footer with a given format -suchas
> "Page X of Y"- when my footer has already text?
>
> Thanks

I require the programmatic solution for this problem.
Thanks,
Ron

"JP" wrote:

> Excel version?
>
> If 2003, go to File > Page Setup > Header/Footer tab, click "Custom
> Footer", click in the Center Section, click the end of your text and
> press the [+] button (the second button from the left) then type " of
> " and click the [++] button (the third button from the left).
>
> Does that work, or did you want a programmatic solution?
>
> --JP
>
> On Oct 2, 2:43 pm, Jess <J...@discussions.microsoft.com> wrote:
> > How can I add page numbers to the center footer with a given format -such as
> > "Page X of Y"- when my footer has already text?
> >
> > Thanks
>
>