Show All
FooterMargin Property
Returns or sets the distance from the bottom of the page to the footer, in points. Read/write Double.
This example sets the footer margin of Sheet1 to 0.5 inch.
Worksheets("Sheet1").PageSetup.FooterMargin = _
Application.InchesToPoints(0.5)