FooterMargin Property

Returns or sets the distance from the bottom of the page to the footer, in points. Read/write Double.

Example

This example sets the footer margin of Sheet1 to 0.5 inch.

Worksheets("Sheet1").PageSetup.FooterMargin = _
        Application.InchesToPoints(0.5)