Macro Sheets Only
Equivalent to displaying a list of views in the View Manager dialog box, which appears when you choose the View Manager command from the View menu. Returns an array of views from the active workbook.
If this function is not available, you must install the View Manager add-in macro.
Syntax
VIEW.GET(type_num, view_name)
Type_num is a number from 1 to 3 that specifies the type of information to return, as shown in the following table.
Type_num Result
1 Returns an array of views from all the sheets in the active workbook or the #N/A error value if none are defined.
2 Returns TRUE if print settings are included in the specified view. Returns FALSE if print settings are not included. Returns the #VALUE! error value if the name is invalid or the workbook is protected.
3 Returns TRUE if row and column settings are included in the specified view. Returns FALSE if row and column settings are not included. Returns the #VALUE! error value if the name is invalid or the workbook is protected.
View_name is text enclosed in quotation marks and specifies the name of a view in the active workbook. View_name is required if type_num is 2 or 3.
Example
The following macro formula returns an array of views from the active workbook:
VIEW.GET(1)
Related Functions
VIEW.DEFINE Creates or replaces a view
VIEW.DELETE Removes a view from the active workbook
VIEW.SHOW Shows a view
List of Information Functions