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.