The FooterMargin property returns or sets the footer margin distance for the worksheet. Returns a double.
Syntax
object.FooterMargin
object.FooterMargin = Margin
|
Parameter |
Type |
Description |
|
Margin |
Double |
required; footer distance from the edge of page in inches |
Remarks
There are no header or footer options in the map window.
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