Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 345
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 345
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Remove big gray page number on Page Break Preview??? annafred Excel Discussion (Misc queries) 1 January 9th 07 02:28 AM
page number watermark in page break preview juga Excel Discussion (Misc queries) 2 December 25th 06 10:17 AM
change page number watermark in page break preview juga Excel Discussion (Misc queries) 2 December 25th 06 10:16 AM
change and/or remove page number watermark in page break preview juga Excel Discussion (Misc queries) 2 December 25th 06 10:15 AM
Hiding the page number in page break preview background. I need coffee, wake me up! Excel Discussion (Misc queries) 0 May 15th 06 10:32 AM


All times are GMT +1. The time now is 12:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"