Page Break Preview Page Number as Data

[Neal Zimm]

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

[Neal Zimm]

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

[Neal Zimm]

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