Macro Sheets Only
Equivalent to choosing the Print button from the Print Reports dialog box. Prints a report.
If this function is not available, you must install the Reports add-in macro.
Syntax
REPORT.PRINT(report_name, copies_num, show_print_dlg_logical)
REPORT.PRINT?(report_name, copies_num)
Report_name specifies the name of a report in the active workbook.
Copies_num is the number of copies you want to print. If omitted, the default is 1.
Show_print_dlg_logical is a logical value that, if TRUE, displays a dialog box asking how many copies to print, or, if FALSE or omitted, prints the report immediately using existing print settings.
Remarks
REPORT.PRINT returns the #VALUE! error value if report_name is invalid or if the workbook is protected.
Related Functions
REPORT.DEFINE Creates a report
REPORT.DELETE Removes a report from the active workbook
List of Command-Equivalent Functions