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