REPORT.DEFINE

Macro Sheets Only

Equivalent to choosing the Print Report command from the View menu and then choosing the Add option from the Print Report dialog box. Creates or replaces a report definition. If this function is not available, you must install the Reports add-in macro.

Syntax

REPORT.DEFINE(report_name, sections_array, pages_logical)

Report_name specifies the name of the report. If the workbook already contains a report with report_name, the new report replaces the existing one.

Sections_array is an array that contains one or more rows of view, scenario, and sheet name that define the report. The sheet name is the sheet on which the view and scenario are defined. If the sheet name is not specified, the current sheet is used when REPORT.DEFINE is run.

Pages_logical is a logical value that, if TRUE or omitted, specifies continuous page numbers for multiple sections or, if FALSE, resets page numbers to 1 for each new section.

Remarks

• REPORT.DEFINE returns the #VALUE error value if report_name is invalid or if the workbook is protected.
• If there are no reports defined, this funcition will bring up the Add Report dialog box

Related Functions

REPORT.DELETE Removes a report from the active workbook

REPORT.PRINT Prints a report

REPORT.GET Returns information about reports defined for the active workbook

List of Command-Equivalent Functions