Export (0) Print
Expand All

AutoFill Method [Excel 2003 VBA Language Reference]

Office 2003

Performs an autofill on the cells in the specified range. Variant.

expression .AutoFill(Destination, Type)

expression Required. An expression that returns one of the objects in the Applies To list.

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

XlAutoFillType can be one of these XlAutoFillType constants.
xlFillDays
xlFillFormats
xlFillSeries
xlFillWeekdays
xlGrowthTrend
xlFillCopy
xlFillDefault default
xlFillMonths
xlFillValues
xlFillYears
xlLinearTrend
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
		


Applies to | Range Collection


Show:
© 2014 Microsoft