Range.Delete (Excel)
Deletes the object.
Delete (Shift)
Shift: Used only with Range objects. Specifies how to shift cells to replace deleted cells. Can be one of the following XlDeleteShiftDirection constants: xlShiftToLeft or xlShiftUp. If this argument is omitted, Microsoft Excel decides based on the shape of the range.
ActiveCell.Delete