SparklineGroup.ModifyLocation Method (Excel)
Sets the associated Range object to modify the location of the sparkline group.
Version Information
Version Added: Excel 2010
Syntax
expression .ModifyLocation(Location)
expression A variable that represents a SparklineGroup object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Location |
Required |
Range |
The Range that represents the location of the sparkline group. |
Return Value
Nothing
Example
This example selects a sparkline group in the location A1:A4 and changes the location to equal A10:A14.
Range("A1:A4").Select
ActiveCell.SparklineGroups.Item(1).ModifyLocation Range("$A$10:$A$14")