FooterMargin Property
The FooterMargin property returns or sets the worksheet footer margin distance. Returns a Double.
Syntax
object.FooterMargin
object.FooterMargin = Margin
Parameter | Type | Description |
Margin | Double | required, distance in inches |
Example 1
This example demonstrates how to return the location of the footer from the bottom edge of the printed page.
Debug.Print WksPageSetup.FooterMargin
Example 2
This example demonstrates how to set the footer 0.25 inches from the bottom edge of the printed page.
WksPageSetup.FooterMargin= 0.25
Used by: WksPageSetup object