Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to detect Height of the printable area in Excel Print Preview?
- Thread starter mtchary
- Start date
What you'd need to do is:
a) calculate this maximum possible number of points height within the page margins; then
b) add up the point heights of all rows until you can't fit any more into the number of number of points height within the page margins, keeping a row count as you go along.
Cheers
a) calculate this maximum possible number of points height within the page margins; then
b) add up the point heights of all rows until you can't fit any more into the number of number of points height within the page margins, keeping a row count as you go along.
Cheers
- Thread starter
- #3
SkipVought
Programmer
mtchary,
What is your ultimate objective beyond having a value for the height?
Skip,
Be advised: Alcohol and Calculus do not mix!
If you drink, don't derive!
Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244
What is your ultimate objective beyond having a value for the height?
Skip,
Be advised: Alcohol and Calculus do not mix!
If you drink, don't derive!
Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244
Hi mtchary,
When you say "Excel has it is own routine to determin(e) height of printable area, and this value (may) vary depend(ing) on font stle and size", that is only because Excel adjusts row heights to suit the font requirements. If you were to fix the row heights, then changing fonts would have no effect.
Take a look at the 'table craziness' thread in this forum from 29 July for a discussion on fitting Word tables to page heights. Although that discussion concerned making a given number of rows fit the page, it deals with many of the same issues you'd be dealing with in tring to determine how many rows from an Excel spreadsheet would print on a page.
Cheers
When you say "Excel has it is own routine to determin(e) height of printable area, and this value (may) vary depend(ing) on font stle and size", that is only because Excel adjusts row heights to suit the font requirements. If you were to fix the row heights, then changing fonts would have no effect.
Take a look at the 'table craziness' thread in this forum from 29 July for a discussion on fitting Word tables to page heights. Although that discussion concerned making a given number of rows fit the page, it deals with many of the same issues you'd be dealing with in tring to determine how many rows from an Excel spreadsheet would print on a page.
Cheers
- Status
Similar threads
- Locked
- Question