Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there a way to determine the range of cells on a page using VBA?
I'm defining a page as the cells within a series of page breaks, automatic or manual. So if it worksheet contains items in the first 3 rows and 5 columns, then usedrange property would return the first 3 rows and 5 columns. However after a print preview Excel displays page breaks after column I and after row 52. How can I determine this range through VBA, since these page breaks do not appear through HPagebreaks or VPagebreaks. -- Eric Howard Director of Process Automation Synergis Technologies, Inc. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Looking for numbers in page range | Excel Worksheet Functions | |||
Printing Range at the beginning of every new page. | Excel Programming | |||
Refer to Range Name in Page Header | Excel Programming | |||
Selecting all contents on page (range) | Excel Programming | |||
How to Programmatically Insert a Page Break Every Nth Row in a Range | Excel Programming |