SparklineGroup.Location property (Excel)
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.