Export (0) Print
Expand All
Expand Minimize

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
)

Parameters

Destination
Type: Microsoft.Office.Interop.Excel.Range

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

Type
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

Community Additions

ADD
Show:
© 2014 Microsoft