BottomMargin Property [WksPageSetup]

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 inches

 

Example 1

This example demonstrates how to return the distance, in inches, 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 page.

WksPageSetup.BottomMargin = 1

 

Used by: WksPageSetup object