Range.AutoFill method

Performs an autofill on the cells in the specified range.

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

Object AutoFill(
	Range Destination,
	XlAutoFillType Type


Type: Microsoft.Office.Interop.Excel.Range

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

Type: Microsoft.Office.Interop.Excel.XlAutoFillType

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.

Return value

Type: System.Object