BottomMargin Property [Worksheet]

BottomMargin returns or sets the bottom margin distance in page units. 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 printed 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