Set the page setup options of one or all worksheets.
Overload Name | Description |
---|---|
Center | Specify whether/how to center the grid on the page. |
Fit | Specify how to fit grid onto the printed page. Use either ZoomPercent or the FitTo properties. |
General | General print settings. |
HeadersAndFooters | Specify headers and footers. |
Margins | Set print margins. |
Titles | Specify areas on the worksheet to use as titles. |
Specify whether/how to center the grid on the page.
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
|
CenterHorizontally |
Whether to center the print area horizontally on the page.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CenterVertically |
Whether to center the print area vertically on the page.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Specify how to fit grid onto the printed page. Use either ZoomPercent or the FitTo properties.
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
|
ZoomPercent | The Print zoom factor. |
FitToPagesWide | Specify a number of pages wide to fit the print range into. |
FitToPagesTall | Specify a number of pages tall to fit the print range into. |
General print settings.
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
|
PrintArea | The address of the print area range. |
Orientation |
Whether to print in Landscape or Portrait mode.
Specify one of the following values or an arbitrary value:
<blank> Landscape Portrait
|
FirstPageNumber | The page number to start with. |
PrintGridLines |
Whether to print grid lines.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
PrintRowColumnHeaders |
Whether to print row and column headers.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
BlackAndWhite |
Whether to print in black and white.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
PrintComments |
Select where to print comments.
Specify one of the following values or an arbitrary value:
<blank> None At End of Worksheet As Displayed on Worksheet
|
PageOrder |
Select how order the pages.
Specify one of the following values or an arbitrary value:
<blank> Down Then Over Over Then Down
|
Specify headers and footers.
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
|
LeftHeader | Text for the left header area. |
CenterHeader | Text for the center header area. |
RightHeader | Text for the right header area. |
LeftFooter | Text for the left footer area. |
CenterFooter | Text for the center footer area. |
RightFooter | Text for the right footer area. |
Set print margins.
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
|
TopMargin | The top margin of the page. |
BottomMargin | The bottom margin of the page. |
LeftMargin | The left margin of the page. |
RightMargin | The right margin of the page. |
HeaderMargin | The header margin. |
FooterMargin | The footer margin. |
Specify areas on the worksheet to use as titles.
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
|
TitleRows | Row range specification for row titles. |
TitleColumns | Column range specification for column titles. |