Skip to content

Latest commit

 

History

History
49 lines (29 loc) · 1.06 KB

Excel.SparklineGroup.ModifyDateRange.md

File metadata and controls

49 lines (29 loc) · 1.06 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
SparklineGroup.ModifyDateRange method (Excel)
vbaxl10.chm871082
vbaxl10.chm871082
Excel.SparklineGroup.ModifyDateRange
2de21c82-64b6-6095-0c47-cd20354d9739
05/16/2019
medium

SparklineGroup.ModifyDateRange method (Excel)

Sets the date range for the sparkline group.

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 don't contain date values, the data is not displayed.

Range("A2:A5").Select 
ActiveCell.SparklineGroups.Item(1).ModifyDateRange "Sheet1!B1:E1"

[!includeSupport and feedback]