Range.AutoFill Method (Excel)
Performs an autofill on the cells in the specified range.
expression .AutoFill(Destination, Type)
expression A variable that represents a Range object.
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.