vba empty cell = 1 code example Example: excel vba set cell value to empty Range("A1:D5").ClearContents