ActiveX

To specify a range of pages 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. Specify the range of pages you want to print with the PrintPageStart and PrintPageEnd properties.
4. Set the PrintType property to 3 (Page Range).
5. Call the PrintSheet method.