Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine maximum length of a page
Hi:
ActiveSheet.HPageBreaks(1).Location.Row - 1 will give you the last row in the first page. In general, this would then give you the number of rows that would fit on a page, assuming they were all the same height, no rows were repeated at the top, etc., etc. Regards, Vasant. "MacroMan" wrote in message ... Please Help! I am using VBA in Excel XP with Windows 2000. I think this is a tough one, but it would help me immensely: Is there a way to determine the maximum number of rows per page, given the current print settings of any particular sheet? Perhaps a calculation based on the row height, etc? Your example code would be most appreciated. Thanks in advance for your assistance... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maximum length of file name? | Excel Discussion (Misc queries) | |||
How to determine the arc length in Excel? | Excel Discussion (Misc queries) | |||
Maximum length of a number | Excel Worksheet Functions | |||
what is maximum row length in excel | Excel Discussion (Misc queries) | |||
maximum formula length | Excel Worksheet Functions |