Expand Minimize

Application.QuickAnalysis Property (Excel)

Office 2013

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

Version Added: Excel 2013

expression .QuickAnalysis

expression A variable that represents an Application object.

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

QUICKANALYSIS

Show:
© 2014 Microsoft