Returns or sets the distance from the bottom of the page to the footer, in points. Read/write Double .
expression . FooterMargin
expression A variable that represents a PageSetup object.
This example sets the footer margin of Sheet1 to 0.5 inch.
Worksheets("Sheet1").PageSetup.FooterMargin = _
Application.InchesToPoints(0.5)