TopMargin Property [WksPageSetup]

TopMargin returns or sets the top margin distance in page units. Returns a double.

Syntax

object.TopMargin

object. TopMargin = Margin

Parameter

Type

Description

Margin

Double

required, use page units

Example 1

This example demonstrates how to return the top margin of a worksheet page to be printed.

Debug.Print WksPageSetup.TopMargin

Example 2

This example demonstrates how to set the left margin of a worksheet page to be printed to 0.5 page units.

WksPageSetup.TopMargin = 0.5

Used by: WksPageSetup object