The Clear method deletes the contents and formatting of all the cells in the worksheet range.
Syntax
object.Clear
Example
This example demonstrates how to clear a range of cells.
WksRange.Clear
Used by: WksRange object