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