The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

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

Community Additions