View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marc[_13_] Marc[_13_] is offline
external usenet poster
 
Posts: 1
Default 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