How to format spreadsheets in VB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Look here:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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
 
Back
Top