AutoFill Method

Applies To

Range object.

Description

Performs an autofill on the cells in the specified range.

Syntax

expression.AutoFill(Destination, Type)

expression Required. An expression that returns a Range object.

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

Type Optional Variant. Specifies the fill type. Can be one of the following XlFillType constants: xlFillDefault, xlFillSeries, xlFillCopy, xlFillFormats, xlFillValues, xlFillDays, xlFillWeekdays, xlFillMonths, xlFillYears, xlLinearTrend, or xlGrowthTrend. If this argument is xlFillDefault or omitted, Microsoft Excel selects the most appropriate fill type, based on the source range.

Example

This example performs an autofill on cells A1:A20 on Sheet1, based on the source range A1:A2 on Sheet1. Before running this example, type 1 in cell A1 and type 2 in cell A2.

Set sourceRange = Worksheets("Sheet1").Range("A1:A2")
Set fillRange = Worksheets("Sheet1").Range("A1:A20")
sourceRange.AutoFill Destination:=fillRange