Improve "Fit Sheet on One Page"! Alter print area ratio to = A4 sheet ratio

I often use 'Fit Sheet on One Page'. However this works by shrinking the printout so that it fits on one page.

If your sheets print area height/width ratio is out to the ratio of the sheet you are printing on then there will be wasted white space on the sides of the sheet.

My idea is to alter the ratio of the print area so that it matches the ratio of an A4 sheet (1:1.414)

I aim to alter the ratio by proportionally increasing the widths of all columns in the print area.

However before I write this, I need a reliable way to measure the height (being the combined heights of all rows in the print area) and the width (being the combined widths of all columns in the print area). I do know how to get the width of one column or height of one row - but how do I quickly pickup the total height/width of the print area?

Suggestions on how to measure this anyone? (Code appreciated if you can)

As far as i know you would just have to loop through the rows (or columns)... like below. interesting if someone has a better idea.

Please Login or Register  to view this content.

(assuming you set your print area to the used range)

Please Login or Register  to view this content.

Thanks for your help scottiex and AlphaFrog! +1

I will work out some code over the next few days and post the final result here for anyone interested.

As promised, here's my code. It's only the first draft so let me know if anything needs improving and I will update it!

Please Login or Register  to view this content.