Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
detect when columns being written to a worksheet “cross” a vertical page break | Excel Worksheet Functions | |||
Detect page break preview | Excel Programming | |||
save page ,clear page, reuse same page | Excel Programming | |||
Detect page break settings | Excel Worksheet Functions | |||
excel fit to 1 page shows 1 page but not all data is on that page | Excel Programming |