REPORT.GET macro

Returns information about reports defined for the active workbook. Use REPORT.GET to return information you can use in other macro commands that manipulate reports.

If this function is not available, you must install the Report Manager add-in.

Syntax

REPORT.GET(type_num, report_name)

Type_num is a number from 1 to 3 specifying the type of information to return, as shown in the following table.

Type_num	Returns
1	An array of reports from all sheets in the active workbook or the #N/A error value if none are specified
2	An array of views, scenarios, and sheet names for the specified report in the active workbook. REPORT.GET returns the #N/A error value if the scenario check box is not selected. Returns the #VALUE! error value if name is invalid or the workbook is protected.
3	If continuous page numbers are used, returns TRUE. If page numbers start at 1 for each section, returns FALSE. Returns the #VALUE! error value if report_name is invalid or the workbook is protected.

Report_name specifies the name of a report in the active workbook.

Remarks

Report_name is required if type_num is 2 or 3.

Example

The following macro formula returns an array of reports from the active workbook.