I have great Macro doing umpteen things wonderfully, to finish it off I just
wanted to format everything so it would print.

This I had to record (basic VB knowledge only) , and one by one changed
every sheet to landscape, then to 8 point, then adjusted column widths.

Touble is although stuff prior to this is 'complex' it takes seconds,
whereas this formatting takes 'MINUTES' to run.

any tips please, need this finished for tomorrow