| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding the current "print range"
Folks
I am trying to build a function that would take as parameter a single cell and would return a range corresponding to the area that would print on the same page than the said cell. I know that recent XL versions have a "page break preview" mode that does everything I'm looking for... but it doesn't seem to be accessible from the object model. Any idea ? I'm pretty sure this is a common question... Regards --alexT |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Finding the current "print range"
I'm pretty sure this is a common question...
Not at all, you may be the first astonishingly enough. I guess you'd have to find all the pagebreaks, horizontal and vertical and see where your cell falls in. This could get real tricky if you have a multi-area print_area and especially any partial page breaks. -- Jim Rech Excel MVP "Alex T" wrote in message om... | Folks | | I am trying to build a function that would take as parameter a single | cell and would return a range corresponding to the area that would | print on the same page than the said cell. | I know that recent XL versions have a "page break preview" mode that | does everything I'm looking for... but it doesn't seem to be | accessible from the object model. | | Any idea ? I'm pretty sure this is a common question... | | Regards | | --alexT |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Functions for "current" & "previous" month to calculate data | Excel Worksheet Functions | |||
| In Excel 2003 is there a way to prevent "Save As" and "Print"? | Excel Discussion (Misc queries) | |||
| Using "Cells" to write "Range("A:A,H:H").Select" | Excel Programming | |||
| What are the System Tables named "Print Area" & "Print Titles"? | Excel Programming | |||
Linear Mode
