inserting page number in cell

[David White]

I need to be able to have automatic page numbers located
in a cell instead of locating it in the header or footer.
I have seen this done before but can not work out the
coding.

help please!

David

[Tom Ogilvy]

You have to locate all the horizontal and vertical pagebreaks and compute
the numbering.

look at hpagebreaks and vpagebreaks collections.

--
Regards,
Tom Ogilvy

David White <anon...@discussions.microsoft.com> wrote in message
news:01e701c39692$ee283570$a601...@phx.gbl...

[David McRitchie]

Page number of the active cell, Find the page number of the activecell (Sub not formula). Laurent Longre 2000-04-21 programming.
http://google.com/groups?threadm=an_613974661

Some postings by Myrna Larson, that determine the page number for the activecell and think there is one somewhere that does it for a
column of cells. (but could not find it) AN=626272822 2000/05/23, AN=561640908 1999/12/16
http://google.com/groups?threadm=an_626272822
http://google.com/groups?threadm=an_561640908
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Tom Ogilvy" <twog...@msn.com> wrote in message news:vp680kq...@corp.supernews.com...