Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Macros
When creating a macro in Excel 2003, is there a way to change the margins and
print area within the macro? Every time I have tried Excel does not like it and normally stops the macro in that location of code. Thanks, Trisha |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Macros
hi
not sure what you mean but is this what you're look for???? With ActiveSheet.PageSetup .PrintArea = "$A$1:$J$20" .LeftMargin = Application.InchesToPoints(0.5) .RightMargin = Application.InchesToPoints(0.5) .TopMargin = Application.InchesToPoints(0.85) .BottomMargin = Application.InchesToPoints(0.85) .HeaderMargin = Application.InchesToPoints(0.15) .FooterMargin = Application.InchesToPoints(0.15) End With regards FSt1 "TJAC" wrote: When creating a macro in Excel 2003, is there a way to change the margins and print area within the macro? Every time I have tried Excel does not like it and normally stops the macro in that location of code. Thanks, Trisha |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
Macros warning always shows up, even if all macros removed | Excel Discussion (Misc queries) | |||
Macros - copying macros from one computer to another | Excel Discussion (Misc queries) | |||
Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions | |||
Excel Macros | Excel Discussion (Misc queries) |