This example sets the header margin of Sheet1 to 0.5 inch.Worksheets("Sheet1").PageSetup.HeaderMargin = _ Application.InchesToPoints(0.5)This example sets the footer margin of Sheet1 to 0.5 inch.Worksheets("Sheet1").PageSetup.FooterMargin = _ Application.InchesToPoints(0.5)
Application.InchesToPoints(0.5)This example sets the footer margin of Sheet1 to 0.5 inch.Worksheets("Sheet1").PageSetup.FooterMargin = _
Application.InchesToPoints(0.5)