Hi Guys,

I was wondering if anyone had some info that could point me in the right direction for automatically setting the print 'Adjust to size' setting using a formula to calculate optimum Column Width vs Row heights or something along those lines.

reason being..
i want to have a macro that will automatically best fit the sheet to one A4 landscape page to print such that the print area utilises as much of the A4 sheet as possible when printing.
I have tried this in the past using Fit to 1 sheet wide by 1 sheet tall however this still doesnt properly utilise the full page during the print.
The number of rows to print changes each time the macro runs, but the column width does not.

Some direction on this would be greatly appreciated!
thanks a bunch