QuickAnalysis Members (Excel)

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

Methods

Name

Description

Hide

Hides specific members of the Analysis Lens user interface.

Show

Displays specific members of the Analysis Lens user interface.

Properties

Name

Description

Application

Returns an Application object that represents the Microsoft Excel application. Read-only.

Creator

Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long.

Parent

Returns an Object that represents the parent object of the specified QuickAnalysis Object (Excel) object. Read-only.