QuickAnalysis object (Excel)

Object that enables single-click access to data analysis features such as formulas, conditional formatting, sparklines, tables, charts, and PivotTables.

Example

This sample illustrates using the QuickAnalysis.Hide method (Excel) method of the QuickAnalysis object. In this example, the 1 argument specifies that, if displayed, the Conditional Formatting & Sparklines callouts are hidden.

ActiveWorksheet.QuickAnalysis.Hide(1)

See also