Delete Method

This method deletes the cells in the range. Its syntax is:

RangeObject.Delete(Shift)

The optional Shift parameter specifies how to shift cells to replace the deleted cells. It can be one of the following constants:

Enum XlDeleteShiftDirection xlShiftUp = -4162 xlShiftToLeft = -4159 End Enum

If this argument is omitted, then Excel guesses based on the shape of the range. In view of this, I would advise always including the argument. (Applications should not guess!)

0 0

Post a comment