Type_num Returns

49 The starting page number, or the #N/A error value if none is specified or if "Auto" is entered in the First page Number text box on the Page tab of the Page Setup dialog box.
50 The total number of pages that would be printed based on current settings, excluding notes, or 1 if the document is a chart.
51 The total number of pages that would be printed if you print only notes, or the #N/A error value if the document is a chart.
52 Four-item horizontal array indicating the margin settings (left, right, top, bottom) in the currently specified units.
53 A number indicating the orientation:
1 = Portrait
2 = Landscape
54 The header as a text string, including formatting codes.
55 The footer as a text string, including formatting codes.
56 Horizontal array of two logical values corresponding to horizontal and vertical centering.
57 If row or column headings are to be printed, returns TRUE; otherwise, returns FALSE.

58 If gridlines are to be printed, returns TRUE; otherwise, returns FALSE.
59 If the sheet is printed in black and white only, returns TRUE; otherwise, returns FALSE.
60 A number from 1 to 3 indicating how the chart will be sized when it's printed:
1 = Size on screen
2 = Scale to fit page
3 = Use full page
61 A number indicating the pagination order:
1 = Down, then Over
2 = Over, then Down
Returns the #N/A error value if the document is a chart.
62 Percentage of reduction or enlargement, or 100% if none is specified. Returns the #N/A error value if not supported by the current printer or if the document is a chart.
63 A two-item horizontal array indicating the number of pages to which the printout should be scaled to fit, with the first item equal to the width (or #N/A if no width scaling is specified) and the second item equal to the height (or #N/A if no height scaling is specified). #N/A is also returned if the document is a chart.

64 An array of row numbers corresponding to rows that are immediately below a manual or automatic page break.
65 An array of column numbers corresponding to columns that are immediately to the right of a manual or automatic page break.

Note GET.DOCUMENT(62) and GET.DOCUMENT(63) are mutually exclusive. If one returns a value, then the other returns the #N/A error value.

The next values of type_num correspond to various document settings.

Type_num Returns

66 In Microsoft Excel for Windows, if the Transition Formula Entry check box is selected in the Transition tab of the Options dialog box, returns TRUE; otherwise, returns FALSE.
67 Microsoft Excel 5.0 always returns TRUE here.
68 Microsoft Excel 5.0 always returns the book name.
69 Returns TRUE if Automatic Page Breaks is chosen in the View tab of the Options dialog box; otherwise, returns FALSE.
70 Returns the names of all the PivotTables in the document.
71 Returns an horizontal array of all the styles in a document.
72 Returns an horizontal array of all chart types displayed on the current sheet.
73 Returns an array of the number of series in each chart of the current sheet.
74 Returns the object id of the control that currently has the focus on a running user-defined dialog (based on the dialog sheet).

75 Returns the object id of the object that is the current default button on a running user-defined dialog (based on the dialog sheet).
76 Returns the name of the active sheet or macro sheet in the form [Book1]Sheet1.
77 Returns the paper size, as integer:
1 = Letter 8.5 x 11 in
2 = Letter Small 8.5 x 11 in
5 = Legal 8.5 x 14 in
9 = A4 210 x 297 mm
10 = A4 Small 210 x 297 mm
13 = B5 182 x 257 mm
18 = Note 8.5 x 11 in
78 Returns the print resolution, as a horizontal array of two numbers.
79 Returns TRUE if the Draft Quality check box has been selected from the sheet tab in the Page Setup dialog box; otherwise, returns FALSE.
80 Returns TRUE if the Notes checkbox has been selected on the Sheet tab in the Page Setup dialog box; otherwise, returns FALSE.

81 Returns the print area from the Sheet tab of the Page Setup dialog box as a cell reference.
82 Returns the print titles from the Sheet tab of the Page Setup dialog box as an array of cell references.
83 Returns TRUE if the worksheet is protected for scenarios; otherwise, returns FALSE.
84 Returns the value of the first circular reference on the sheet, or #N/A if there are no circular references.
85 Returns the advanced filter mode state of the sheet. This is the mode without drop-down arrows on top. Returns TRUE if the list has been filtered by choosing Filter, then Advanced Filter from the Data menu. Otherwise, returns FALSE.
86 Returns the automatic filter mode state of the sheet. This is the mode with drop-down arrows on top. Returns TRUE if you have chosen Filter, then AutoFilter from the Data menu and the filter drop-down arrows are displayed. Otherwise, returns FALSE.

87 Returns the position number of the sheet. The first sheet is position 1. Hidden sheet are included in the count.
88 Returns the name of the active workbook in the form "Book1".

Name_text is the name of an open document. If name_text is omitted, it is assumed to be the active document.