Hi emptycucumber,

Glad it worked

The following will delete all contents within cell A5...

Range("A5").ClearContents
...while the following will delete all contents from the range A5:B10:

Range("A5:B10").ClearContents
HTH

Robert