FooterMargin Property

FooterMargin 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; distance in inches

Remarks

There are no header or footer options in the plot 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 page units from the bottom edge of the printed page.

WksPageSetup.FooterMargin = 0.25

Used by: WksPageSetup object