| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help setting the worksheet header/Footer margins based on string height?
I was able to improve the results by adding the value of HeaderMargin
and FooterMargin to the strings height but it's sill not 100% perfect. It's almost perfect for 1 or two lines but for 3 or more the strHeight+HeaderMargin starts to get too big. Anyone have any Ideas? This is part of a macro to transform a set of cross tabs to charts. Doug |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Header and Footer margins | Excel Discussion (Misc queries) | |||
| Need help setting the worksheet header/Footer margins based on string height? | Excel Discussion (Misc queries) | |||
| Header/Footer side margins | Excel Discussion (Misc queries) | |||
| MACRO FOR SETTING MARGINS WITHOUT OVERRIDING HEADER AND FOOTER | Excel Discussion (Misc queries) | |||
| Left/Right Margins in Header/Footer | Excel Discussion (Misc queries) | |||
Hybrid Mode
