Excel.HPageBreaks.Item.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
HPageBreaks.Item property (Excel)	vbaxl10.chm165073	vbaxl10.chm165073	Excel.HPageBreaks.Item	2c216336-ed46-382b-e408-3de708afb3c3	04/26/2019	medium

HPageBreaks.Item property (Excel)

Returns a single object from a collection.

Syntax

expression.Item (Index)

expression A variable that represents an HPageBreaks object.

Parameters

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

Example

This example changes the location of horizontal page break one.

Worksheets(1).HPageBreaks.Item(1).Location = .Range("e5")

[!includeSupport and feedback]