VPageBreak.Location Property

Excel Developer Reference

Returns or sets the cell (a Range object) that defines the page-break location. Horizontal page breaks are aligned with the top edge of the location cell; vertical page breaks are aligned with the left edge of the location cell. Read/write Range.

Syntax

expression.Location

expression   A variable that represents a VPageBreak object.

Example

This example moves the vertical page-break location.

Visual Basic for Applications
  Worksheets(1).VPageBreaks(1).Location = Worksheets(1).Range("e5")

See Also