TopMargin Property [WksPageSetup]

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 inches

 

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 inches.

WksPageSetup.TopMargin= 0.5

 

Used by: WksPageSetup object