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!!!