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

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