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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditonal formatting in VB 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Excel How to change the "Short Date" format in Excel? 4
how to remove all formatting 14
how do I convert a spreadsheet to landscape format? 3
Formatted cell column in drop down list 1
Format date in destination cell 1
Conditional formatting 2

Back
Top