Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Page Break Preview Page Number as Data
found another way.
in my application a given number of rows constitutes a page in a book, so the gist of what I needed is: rownum=activecell.row page= rownum / rows per page "Neal Zimm" wrote: I can't find a function to access the number you see in gray in the background in this view. Is there code to 'get at it'? Thanks. -- Neal Z |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Page Break Preview Page Number as Data
For the others out there, recent news is that hpagebreaks.count gives the
number of page breaks in a documents, SOOOOOOOOOOOO, hpagebreaks.count + 1 is the number of pages a worksheet has. IT'S SO SIMPLE WHEN YOU KNOW IT, AND SO TOUGH WHEN YOU DON'T. "Neal Zimm" wrote: found another way. in my application a given number of rows constitutes a page in a book, so the gist of what I needed is: rownum=activecell.row page= rownum / rows per page "Neal Zimm" wrote: I can't find a function to access the number you see in gray in the background in this view. Is there code to 'get at it'? Thanks. -- Neal Z |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove big gray page number on Page Break Preview??? | Excel Discussion (Misc queries) | |||
page number watermark in page break preview | Excel Discussion (Misc queries) | |||
change page number watermark in page break preview | 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) |