How to calculate a page number
 

Hi,

Given a position on a given Sheet (either cell or X/Y is
OK), I need to calculate the page number on which the
cell appears.

Another way to look at it would be to be able for a given
page number to return the topleft and bottomright cell
range that fits on that page.

Is there a function or formula to do this ?

Thanks

How to calculate a page number
 

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

Some postings by Myrna Larson, that determine the page number for the activecell
http://groups.google.com/groups?oi=d...m=an_626272822
http://groups.google.com/groups?oi=d...m=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

"Marc" wrote in message ...
Hi,

Given a position on a given Sheet (either cell or X/Y is
OK), I need to calculate the page number on which the
cell appears.

Another way to look at it would be to be able for a given
page number to return the topleft and bottomright cell
range that fits on that page.

Is there a function or formula to do this ?

Thanks