HeaderMargin Property

HeaderMargin returns or sets the header margin distance in the worksheet. Returns a double.

Syntax

object.HeaderMargin

object. HeaderMargin = 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 header from the top edge of the printed page.

Debug.Print WksPageSetup.HeaderMargin

Example 2

This example demonstrates how to set the footer 0.25 inches from the bottom edge of the printed page.

WksPageSetup.HeaderMargin = 0.25

Used by: WksPageSetup object