Syntax

expression.BottomMargin

expression A variable that represents a PageSetup object.

Remarks

Margins are set or returned in points. Use either the method or the method to do the conversion.

Example

These two examples set the bottom margin of Sheet1 to 0.5 inch (36 points).

Visual Basic for Applications 
Worksheets("Sheet1").PageSetup.BottomMargin = _ Application.InchesToPoints(0.5) Worksheets("Sheet1").PageSetup.BottomMargin = 36

This example displays the current setting for the bottom margin on Sheet1.

Visual Basic for Applications 
marginInches = Worksheets("Sheet1").PageSetup.BottomMargin / _ Application.InchesToPoints(1) MsgBox "The current bottom margin is " & marginInches & " inches"
bottom bottom margin Bottom Margin Property BottomMargin bottommargin property Change the bottom margin on the printed page? Find out the height of the bottom margin of pagesetup object? Resize the margin at the bottom? Set the bottom margin at 72 points?

See also: