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