다음을 통해 공유

Range.AutoFill Method (Excel)

  • 아티클

Performs an autofill on the cells in the specified range.

Syntax

식 .AutoFill(Destination, Type)

식 A variable that represents a Range object.

Parameters

Name

Required/Optional

Data Type

Description

Destination

필수

Range

The cells to be filled. The destination must include the source range.

Type

선택

XlAutoFillType

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

참고 항목

개념

Range Object

Range Object Members