Excel 2010 Macro How to Check If Cell Is Empty
The ISEMPTY function returns a Boolean value of whether a single cell is empty; True if empty, False if not. The cell must truly be empty. Even if it has a space that you cannot see, Excel does not consider the cell to be empty:
IsEmpty(Cell)