Clear Method Example
This example clears the formulas and formatting in cells A1:G37 on Sheet1.
Worksheets("Sheet1").Range("A1:G37").Clear
This example clears the chart area (the chart data and formatting) of Chart1.
Charts("Chart1").ChartArea.Clear