Excel.application.quickanalysis.md

title	keywords	f1_keywords	ms.assetid	ms.date	ms.localizationpriority
Application.QuickAnalysis property (Excel)	vbaxl10.chm133338	vbaxl10.chm133338	c79c04e7-0caf-470c-ee6d-dc613d6a4cf5	04/05/2019	medium

Application.QuickAnalysis property (Excel)

Returns a QuickAnalysis object that represents the Quick Analysis options of the application.

Syntax

expression.QuickAnalysis

expression A variable that represents an Application object.

Property value

QUICKANALYSIS

Example

The following example displays the Quick Analysis contextual UI with the Sparklines option highlighted.

Sub ShowQuickAnalysisOptions()

'Displays the Quick Analysis contextual UI with the Sparklines option highlighted.
  Application.QuickAnalysis.Show (xlSparklines)

End Sub

[!includeSupport and feedback]