ActiveX

To print the portion of the sheet with data

At run time,

1. Set the Sheet property to specify the sheet to print.
2. Set the PrintUseDataMax property to True.
3. Call the PrintSheet method.