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)?



"Kaval" wrote:

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