with oExcel.ActiveSheet.PageSetup .LeftMargin = .35 .RightMargin = .35 .FitToPagesWide = 1 .FitToPagesTall = 1 endwith