Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Page Numbers
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Page Numbers
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Page Numbers
It is a single worksheet and single print range (default page numbers
starting from 1). "Bill Pfister" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Page Numbers
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 "Kaval" wrote: It is a single worksheet and single print range (default page numbers starting from 1). "Bill Pfister" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Page numbers in page break view | Excel Discussion (Misc queries) | |||
Different Page Numbers In Worksheet w/Page Breaks | Excel Discussion (Misc queries) | |||
How can Enter Page Numbers and/or page ranges separated by commas. | Excel Discussion (Misc queries) | |||
Page numbers on copies of a single page worksheet | Excel Discussion (Misc queries) | |||
Add page numbers to multiple worksheets without changing page setu | Excel Discussion (Misc queries) |