insert a page number into a cell?

[Guest]

Is it possible to enter the page number into a cell? I am wanting to insert
a page number as part of a formula.

I know looked up the code for inserting page numbers in the header and
footer, and it doesn't work... this is the formula:

=(CHAR((CODE(A$10))))&" - Page "&[Page]&" of "&[Pages]

Please Help Me!!!

 

[Peo Sjoblom]

Why don't you use page break view?

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Frank Kabel]

Hi
there's no easy solution for this and it would require VBA. You have to
calculate depending on your printer and printer setting where the
pagebreaks ´would occur. So I would also go with Peo's suggestion or
use the header/footer