I have an Excel VBA application I designed to generate a Glucometer Logbook report. Report contains a varying count of rows per day depending on what and how much source data is available.

I've looked everywhere I could think of... Currently working around problem by limiting report to 16 days per page.

How can I determine how many rows of output will fit on the printed pages so I can have the software determine how many days of data to print on each page based on rows available on one page compared to how many rows of data each day needs to use?

I've found how to set up margins, set the type-size, etc. But I've been unable to find a way to determine how many rows of text of the selected size will fit on a single printed page. There MUST be a way to do this, or Excel would be splitting rows in 1/2 with top of row on different page from bottom of same row.

If possible, I'd like to be able to have solution that will work with any version of Excel back to at least Excel 2000 since that's what I have on one of my laptops, but I have Excel 2010 on my Desktop.