Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
spreadsheets | Excel Worksheet Functions | |||
link spreadsheets with data and format | New Users to Excel | |||
How can I move spreadsheets to contain same format and spacing | Excel Discussion (Misc queries) | |||
Can Excel Spreadsheets be saved as Microsoft Works spreadsheets? | Excel Discussion (Misc queries) | |||
how to format excel format to text format with separator "|" in s. | New Users to Excel |