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

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 wrote in message
...
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

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" wrote in message ...
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 wrote in message
...
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