ActiveX
To specify a print page break before a column or row
- Set the Sheet property to specify the sheet for which to set page breaks.
-
If you want to specify a print page break before a column, at run time,
- Specify the column with the Col property.
- Set the ColPageBreak property to True.
-
If you want to specify a print page break before a row, at run time,
- Specify the row with the Row property.
- Set the RowPageBreak property to True.