HeaderMargin Property

Applies To

PageSetup Object.

Description

Returns or sets the distance from the top of the page to the header, in points (1/72 inch). Read-write.

See Also

BottomMargin Property, FooterMargin Property, LeftMargin Property, RightMargin Property, TopMargin Property.

Example

This example sets the header margin of Sheet1 to 0.5 inch.

Worksheets("Sheet1").PageSetup.HeaderMargin = _
        Application.InchesToPoints(0.5)