SparklineGroup.Location Property (Excel)
Gets or sets the Range object that represents the location of the sparkline group. Read/write.
Version Information
Version Added: Excel 2010
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 for the SparklineGroup object.
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.