내보내기(0) 인쇄
모두 확장
확장 최소화

Range.Insert Method (Excel)

Office 2010

Inserts a cell or a range of cells into the worksheet or macro sheet and shifts other cells away to make space.

.Insert(Shift, CopyOrigin)

A variable that represents a Range object.

Parameters

Name

Required/Optional

Data Type

Description

Shift

선택

Variant

Specifies which way to shift the cells. Can be one of the following XlInsertShiftDirection (영문) constants: xlShiftToRight or xlShiftDown. If this argument is omitted, Microsoft Excel decides based on the shape of the range.

CopyOrigin

선택

Variant

The copy origin.

Return Value

Variant

표시:
© 2014 Microsoft