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
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