PFA output pdfs... in one the page width is proper as per the code, while in the other the righ margin has increased. I need the excel to fit the entire page width.
Code
With ActiveSheet.PageSetup
.CenterVertically = True
.Orientation = xlLandscape
.Zoom = False
.FitToPagesWide = 1
.FitToPagesTall = 1
.LeftMargin = Application.InchesToPoints(0.5)
.RightMargin = Application.InchesToPoints(0.75)
.TopMargin = Application.InchesToPoints(1.5)
.BottomMargin = Application.InchesToPoints(1)
End With
Display More