Worksheet.HPageBreaks (Excel)

Returns an HPageBreaks collection that represents the horizontal page breaks on the sheet.

There is a limit of 1,026 horizontal page breaks per sheet.

Dim hpbsHPageBreaks As HPageBreaks
Set hpbsHPageBreaks = ActiveSheet.HPageBreaks