Delete Method
Delete method as it applies to all objects in the Applies To list except the Range object.
Deletes the specified object.
expression.Delete
*expression * Required. An expression that returns one of the above objects.
Delete method as it applies to the Range object.
Deletes the specified object.
expression.Delete(Shift)
*expression * Required. An expression that returns one of the above objects.
XlDeleteShiftDirection
| XlDeleteShiftDirection can be one of these XlDeleteShiftDirection constants. |
| xlShiftToLeft |
| xlShiftUp
If this argument is omitted, Microsoft Graph decides how to shift cells based on the shape of the specified range. |
Remarks
Deleting a Point or LegendKey object deletes the entire series.
Example
This example deletes cells A1:D10 on the datasheet and shifts the remaining cells to the left.
Set mySheet = myChart.Application.DataSheet
mySheet.Range("A1:D10").Delete Shift:=xlShiftToLeft
This example deletes the chart title.
myChart.ChartTitle.Delete
Applies to | Axis Object | AxisTitle Object | ChartTitle Object | DataLabel Object | DataLabels Collection Object | DataTable Object | DisplayUnitLabel Object | DownBars Object | DropLines Object | ErrorBars Object | Gridlines Object | HiLoLines Object | LeaderLines Object | Legend Object | LegendEntry Object | LegendKey Object | Point Object | Range Object | Series Object | SeriesLines Object | TickLabels Object | Trendline Object | UpBars Object