The HeaderMargin property 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 from the edge of page in page units |
Remarks
There are no header or footer options in the map 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