ClearContents question

[Bidwin]

I understand a "blank" cell may contain spaces or other non-printable characters. If I want to ensure a cell is empty, i.e. contain nothing, can I do that manually by highlighting a cell or a cell's contents and hitting the delete key?

If I want to do that with Visual Basic will "ClearContents" or setting the cell's value to "" (no space(s) between quotes) work?

I'm running Excel for Mac 2011.

Thanks,
Bill

 

[Ron Coderre]

ClearContents will make the cell blank.
The IsBlank function will return: TRUE
In VBA IsEmpty will also return: TRUE