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

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