This documentation is archived and is not being maintained.

Range.AutoFill Method 

Performs an autofill on the cells in the specified range.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in

Dim Destination As Range
Dim Type As XlAutoFillType
Dim returnValue As Object
Dim range1 As Range
returnValue = range1.AutoFill(Destination, Type)

object AutoFill(
	[In] Range Destination, 
	[In, Optional] XlAutoFillType Type
public System.Object AutoFill(
	/*in*/Range Destination, 
	/*in*/XlAutoFillType Type
function AutoFill(
	 Destination : Range, 
	 Type : XlAutoFillType
) : Object;



Required Range object. The cells to be filled. The destination must include the source range.


Optional XlAutoFillType. Specifies the fill type. Can be one of these XlAutoFillType constants:

  • xlFillDays

  • xlFillFormats

  • xlFillSeries

  • xlFillWeekdays

  • xlGrowthTrend

  • xlFillCopy

  • xlFillDefaultdefault

  • xlFillMonths

  • xlFillValues

  • xlFillYears

  • xlLinearTrend

If this argument is xlFillDefault or omitted, Microsoft Excel selects the most appropriate fill type, based on the source range.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms