FillDate(CellRange,FillSeries,FillDateUnit,Double) Method

In This Topic

Fills the specified range when the source value type is date.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub FillDate( _
   ByVal range As CellRange, _
   ByVal series As FillSeries, _
   ByVal unit As FillDateUnit, _
   ByVal step As Double _
)

'Usage
 
Dim instance As Worksheet
Dim range As CellRange
Dim series As FillSeries
Dim unit As FillDateUnit
Dim step As Double
 
instance.FillDate(range, series, unit, step)

public void FillDate( 
   CellRange range,
   FillSeries series,
   FillDateUnit unit,
   double step
)

Parameters

range: The fill range.
series: The fill direction.
unit: The fill date unit.
step: Fills the date using the step value. The step value is the adjacent cells' offset.

Exceptions

Exception	Description
System.ArgumentNullException	The range cannot be null.

Remarks

The next value is generated by adding the step value to the current value. The step value is affected by the fill date unit. The default stop value is positive infinity.

Reference

Worksheet Class
Worksheet Members
Overload List