LeftMargin Property [WksPageSetup]

The LeftMargin property returns or sets the worksheet left margin distance. Returns a Double.

Syntax

object.LeftMargin

object.LeftMargin = Margin

 

Parameter	Type	Description
Margin	Double	required, use inches

 

Example 1

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

Debug.Print WksPageSetup.LeftMargin

 

Example 2

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

WksPageSetup.LeftMargin = 0.5

 

Used by: WksPageSetup object