Share via

VPageBreaks.Item Property

  • Article
Excel Developer Reference

Returns a single object from a collection.

Syntax

expression.Item(Index)

expression   A variable that represents a VPageBreaks object.

Parameters

Name Required/Optional Data Type Description
Index Required Long The index number of the object.

Example

This example changes the location of vertical page break one.

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

See Also