Excel.quickanalysis.md

title	keywords	f1_keywords	ms.assetid	ms.date	ms.localizationpriority
QuickAnalysis object (Excel)	vbaxl10.chm919072	vbaxl10.chm919072	cff69157-e5d9-aacb-2569-9727c5f83b0e	04/02/2019	medium

QuickAnalysis object (Excel)

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

Example

This sample illustrates how to use the Hide method of the QuickAnalysis object. In this example, the 1 argument specifies that, if displayed, the Conditional Formatting and Sparklines callouts are hidden.

ActiveWorksheet.QuickAnalysis.Hide(1)

Methods

• Hide
• Show

Properties

• Application
• Creator
• Parent

See also

• Excel Object Model Reference

[!includeSupport and feedback]