Excel Macros

T

TJAC

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
 
F

FSt1

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
 
Top