FillAuto(CellRange,FillSeries) Method

In This Topic

Fills the specified range automatically.

Syntax

'Declaration
 
Public Overloads Sub FillAuto( _
   ByVal range As CellRange, _
   ByVal series As FillSeries _
)

'Usage
 
Dim instance As Worksheet
Dim range As CellRange
Dim series As FillSeries
 
instance.FillAuto(range, series)

public void FillAuto( 
   CellRange range,
   FillSeries series
)

Exceptions

Exception	Description
System.ArgumentNullException	The range cannot be null.

Remarks

When the value is a string, the value is copied to other cells. When the value is a number, the new value is generated by the TREND formula.