ActiveX

To retrieve the number of the next column or row that is marked as a page break

At run time,

1. Set the Sheet property to specify the sheet for which to return page breaks.
2. If you want to return the number of the next column or row where a page break occurs, return the value of the PrintNextPageBreakCol or PrintNextPageBreakRow property.
   The column or row number returned is the first column or row of the next page.
3. If you want to return all columns or rows where a page breaks occurs, loop through the sheet using the PrintNextPageBreakCol or PrintNextPageBreakRow property.