Print Selection, Sheet, or Workbook.
Overload Name | Description |
---|---|
Preview | PrintPreview Selection, Sheet, or Workbook. |
Print Selection, Sheet, or Workbook. | |
PrintToFile | Print Selection, Sheet, or Workbook to a file. |
PrintPreview Selection, Sheet, or Workbook.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
PrintWhat |
Specifies what to print.
Specify one of the following values or an arbitrary value:
<blank> Selection Sheet Workbook
|
Print Selection, Sheet, or Workbook.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
PrintWhat |
Specifies what to print.
Specify one of the following values or an arbitrary value:
<blank> Selection Sheet Workbook
|
ShowDialog |
Whether to show the print dialog.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Print Selection, Sheet, or Workbook to a file.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
PrintWhat |
Specifies what to print.
Specify one of the following values or an arbitrary value:
<blank> Selection Sheet Workbook
|
PrinterName | Specifies the name of the print driver, such as Microsoft XPS Document Writer. |
Filename | Specify the name of the file. |
FolderOption |
Select which option is used to determine the folder to save the file to. If no option is specified, the Folder argument is used.
Specify one of the following values or an arbitrary value:
<blank> MyDocuments Desktop
|
Folder | Specify the full path of the folder to save the file to. The Folder value is only used when the FolderOption is not specified. |
IncrementFilename |
Whether to add a subscript to the filename if the specified file already exists. If not true, an existing file with the same name will be overwritten.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|