What is the height of the print area?

[kobusb]

I have code to insert footer rows and page breaks into a sheet and it work very well but the footer row is not always at the end of the page, which I understand. I use HPageBreaks property to determine where Excel wants to break a page.

Is there a method to determine how much space is left in the print area. This will allow me to fill up the rest of the page with blank rows before the footer row.

 

[kobusb]

You may be able to recreate my results by using the following parameters:
Page size: A4
Bottom & top Margin: 1.9cm (53.86 points)