Look he

http://www.mcgimpsey.com/excel/udfs/pagesetup.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"JBW" wrote in message ...
|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