BottomMargin Property

 

The BottomMargin property returns or sets the worksheet bottom margin distance. Returns a double.

 

Syntax

object.BottomMargin

object.BottomMargin( Margin )

 

Parameter

Type

Description

Margin

Double

required, use page units

 

Example 1

This example demonstrates how to return the distance in page units between the bottom margin and the edge of the page.

 

Debug.Print WksPageSetup.BottomMargin

 

Example 2

This example demonstrates how to set the bottom margin one inch from the edge of the printed page.

 

WksPageSetup.BottomMargin = 1

 

Used by: WksPageSetup object