PrintPreview Method

Shows a preview of the object as it would look when printed.

expression   Required. An expression that returns an object in the Applies To list.

Example

This example displays Sheet1 in print preview.

Worksheets("Sheet1").PrintPreview