Determine Physical Row Print size

Hi Guys,

I have a question for you in regards to printing!

I want to be able to determine the physical Row size (the height of each Row in mm) of my worksheet.

Using this information I will then proceed to write a macro that uses this sizing to determine how many sheets to print the WS over..
i.e. If the rows are too thin to print the Page break view range on, then split the Print area over 2 sheets.

In doing this I would also like to 'Lock' the size of the Rows such that if the aforementioned splitting occurs then this does not alter the Physical size of the Row Heights once printed

If anyone has done something similiar to this an example WB or sample code would be a great help!

Thanks everyone

any ideas on this one?

Perhaps instead of determining the Row size in mm, i should focus on number of rows for print instead?
and simply set the number of rows to fit to a page depending on how tall the rows are? (in excel)

I've tried this method before but had issues that the print was coming out too small because the number of rows varies each time the print is run. ie sometimes there will be 30 rows to print others there could be 400