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...