How to calculate a page number

[Marc]

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

[David McRitchie]

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=djq&ic=1&selm=an_613974661

Some postings by Myrna Larson, that determine the page number for the activecell
http://groups.google.com/groups?oi=djq&ic=1&selm=an_626272822
http://groups.google.com/groups?oi=djq&ic=1&selm=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" <mri...@novation.com.au> wrote in message news:587501c3a9e2$d2221d60$7d02...@phx.gbl...