Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
ClearContents Method

ClearContents Method

Deletes all data from the specified range.

expression.ClearContents

expression   An expression that returns a Range object.

Example

This example deletes all data from cells A4:B10 on the active worksheet in Spreadhseet1.

Spreadsheet1.ActiveSheet.Range("A4:B10").ClearContents

 

Show:
© 2015 Microsoft