View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NateBuckley NateBuckley is offline
external usenet poster
 
Posts: 146
Default Anyway to detect a new page

Hello I'd like someway to figure out if my loop ends up on a new page, and I
was wondering if there was a check to see if something is on a different page?

For example I was thinking of something along the lines:
dim pageAt as Integer
pageAt = Sheet1.Cells(10, 1).Row.PageOn

for i = 10 to 200
if Sheet1.Cells(i, 1).Row.PageOn < pageAt then
MsgBox("New Page")
pageAt = Sheet1.Cells(i, 1).Row.PageOn
end if

I know there is no PageOn method/property etc but is there anything like
that?
Thanks for anyone who can throw some advice my way.

Nate
next i