ActiveX
To specify a block of cells as a print range
At run time,
- Set the Sheet property to specify the sheet to print.
- Set the PrintUseDataMax property to False.
- Set the Col, Col2, Row, and Row2 properties to specify the block of cells you want to print.
- Set the PrintType property to 1 (Cell Range).
- Call the PrintSheet method.