This topic has not yet been rated - Rate this topic

HPageBreaks.Item Property (Excel)

Published: July 16, 2012

Returns a single object from a collection.

expression .Item(Index)

expression A variable that represents a HPageBreaks object.

Parameters

Name

Required/Optional

Data Type

Description

Index

Required

Long

The index number of the object.

This example changes the location of horizontal page break one.

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

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.