SparklineGroup.ModifyDateRange Method (Excel)
Sets the date range for the sparkline group.
Version Information
Version Added: Excel 2010
Syntax
expression .ModifyDateRange(DateRange)
expression A variable that represents a SparklineGroup object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
DateRange |
Required |
String |
The date range for the sparkline group. |
Return Value
Nothing
Example
This example selects a sparkline group in the location A2:A5 and sets the date range equal to B1:E1. If the cells in range B1:E1 do not contain date values the data is not displayed.
Range("A2:A5").Select
ActiveCell.SparklineGroups.Item(1).ModifyDateRange "Sheet1!B1:E1"