Range.AutoFill Method (Excel)
Performs an autofill on the cells in the specified range.
Syntax
expression .AutoFill(Destination, Type)
expression A variable that represents a Range object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Destination |
Required |
The cells to be filled. The destination must include the source range. |
|
Type |
Optional |
Specifies the fill type. |
Return Value
Variant
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