Szerkesztés

Megosztás a következőn keresztül:

SparklineGroup.Location property (Excel)

  • Cikk

Gets or sets the Range object that represents the location of the sparkline group. Read/write.

Syntax

expression.Location

expression A variable that represents a SparklineGroup object.

Return value

Range

Remarks

The location for all sparklines in a sparkline group must be on the same sheet, but the source data for the sparkline group can be on a different sheet or workbook.

The size of the range that represents the Location property must equal the number of rows or columns in the SourceData property.

A continuous range associated with a sparkline group can only be one-dimensional. If the range is not continuous, each cell must be specified individually.

Note

Do not use the Union method to create a non-continuous range because the Union method returns a single range reference.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.