| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate vertical midpoint of a print area in a sheet
Is it even possible to calculate the midpoint of a sheet taking into account margins, row heights, font sizes, and anything else that could affect it
I am trying to place a graphic (a text box) at the left edge (horizontal) and center of the page (vertical) using VBA. The sheets I have to work with use all different font sizes, margins, row heights, etc. It seems impossible to do. Have I found a limit in VBA If you can accurately calculate this, please, pleasE, pleaSE, pleASE, plEASE, pLEASE, PLEASE post your code so I can solve this mystery. Thanks much in advance for your assistance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Repeating gradient for each vertical area of plot area | Charts and Charting in Excel | |||
| How do I set a print area for every sheet in the workbook? | Excel Discussion (Misc queries) | |||
| How do I calculate the midpoint date between two dates. | Excel Worksheet Functions | |||
| Active cell counting in particular print page (one sheet having different print area) | Excel Worksheet Functions | |||
| Print a sheet area to another... | Excel Discussion (Misc queries) | |||
Threaded Mode
