How to format spreadsheets in VB
 

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

How to format spreadsheets in VB
 

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

How to format spreadsheets in VB
 

Crikey that looks v compliucated to work out for a novice

"Niek Otten" wrote:

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