TopMargin Property

 

The TopMargin property returns or sets the worksheet top margin distance. 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.

 

Debug.Print WksPageSetup. TopMargin

 

Example 2

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

 

WksPageSetup.TopMargin = 0.5

 

Used by: WksPageSetup object