Page Numbers

[Guest]

I would like to write a function that would return the page number on which a
particular cell will print out.

This is for a table of contents & other cross references on a single
spreadsheet for which the print range is multiple pages.

For example, I want cell "C10" to return the page number under the current
print setup for the cell "e120".

Hope it makes sense, Kaval

 

[Guest]

Kaval, do you have a single worksheet or multiple worksheets that you would
consider one print job (i.e. if you have multiple worksheets, does the page
numbering restart on each sheet)?

 

[Guest]

It is a single worksheet and single print range (default page numbers
starting from 1).

 

[Guest]

If you search for "pfister" in the Excel discussion, you'll find two threads
("Print Page Totals" and "Resetting page numbers") that pertain to this
topic. As far as returning the Page number in a cell, you can use a
user-defined function. This function should load/check a global flag and
associated variables to determine the pagebreaks only as often as it needs to
(whenever the workbook opens or is updated), so that you don't kill your calc
times.

Hope this makes sense.

Bill