ActiveX

To specify a block of cells as a print range

At run time,

1. Set the Sheet property to specify the sheet to print.
2. Set the PrintUseDataMax property to False.
3. Set the Col, Col2, Row, and Row2 properties to specify the block of cells you want to print.
4. Set the PrintType property to 1 (Cell Range).
5. Call the PrintSheet method.