Excel Print Margin Problem

[detroitpickles]

All,

I'm trying to set the Print Margin's in Excel's VBA. My settings are not taking when the print margin is something different before you open my file. The code I am using is below. If the "default" worksheet has top and bottom margins of 1.125", then they stay that way.

'Print the specified area
ThisWorkbook.Worksheets("Estimate&quot.PageSetup.PrintArea = "$A$1:$S$90"
ThisWorkbook.Worksheets("Estimate&quot.PageSetup.TopMargin = 0.875
ThisWorkbook.Worksheets("Estimate&quot.PageSetup.BottomMargin = 0.875

Anybody help me?

 

[RobBroekhuis]

Try using
ThisWorkbook.Worksheets("Estimate&quot.PageSetup.TopMargin = Application.InchesToPoints(0.85)

Rob