Deletes the object. Syntax 2 applies only to Range objects.
Syntax 1
expression.Delete
Syntax 2
expression.Delete(Shift)
expression Required. An expression that returns an object in the Applies To list.
Shift Optional Variant. 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.
Remarks
Deleting a Point or LegendKey object deletes the entire series.
You can delete custom document properties, but you cannot delete a built-in document property.