HeaderMargin Property Example

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

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