ActiveX
To specify a range of pages as a print range
At run time,
- Set the Sheet property to specify the sheet to print.
- Set the PrintUseDataMax property to False.
- Specify the range of pages you want to print with the PrintPageStart and PrintPageEnd properties.
- Set the PrintType property to 3 (Page Range).
- Call the PrintSheet method.