Range("A1").Clear
Or Range("A1").ClearContents
Or Range("A1").value = vbNullString
Or Range("A1").value = Empty
I suppose all of the above would work. I use the first or second most of the the time - Clear gets rid of everything, ClearContents leaves formatting in the cell.
HTH