HeaderMargin Property

The HeaderMargin property returns or sets the worksheet header margin distance. Returns a Double.

Syntax

object.HeaderMargin

object.HeaderMargin = Margin

 

Parameter	Type	Description
Margin	Double	required, distance in inches

 

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