Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format page number in excel footer to start at a specific page # | Excel Discussion (Misc queries) | |||
change and/or remove page number watermark in page break preview | Excel Discussion (Misc queries) | |||
Hiding the page number in page break preview background. | Excel Discussion (Misc queries) | |||
sheet tabs as page number and in a cell page of pages? | Excel Discussion (Misc queries) | |||
How do I print a one page spreadsheet multiple time, each with its own page number? | Excel Discussion (Misc queries) |