Insert Method

This method inserts a cell or range of cells into the worksheet, shifting existing cells to make room. The syntax is:

RangeObject.Insert(Shift)

where Shift can be one of the XllnsertShiftDirection constants:

Enum XllnsertShiftDirection xlShiftToRight = -4161 xlShiftDown = -4121 End Enum

If the Shift argument is omitted, Excel will decide upon the shift direction based on the shape of the range. (As with other cases when Excel will guess, I recommend against allowing it to do so.)

0 0

Post a comment