Deletes all data from the specified range.
expression.ClearContents
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