ClearContents Method
Deletes all data from the specified range.
expression An expression that returns a Range object.
This example deletes all data from cells A4:B10 on the active
worksheet in Spreadhseet1.
Spreadsheet1.ActiveSheet.Range("A4:B10").ClearContents