Whenever I need to determine if a cell is blank, I call the IsEmpty function on the Value property. If IsEmpty(ActiveCell.Value) Then This anonymous blogger uses vbNullString. If ActiveCell.Value = vbNullString In other news: In Firefox, Cntl+Click on a hyperlink and it will open that link in a new tab. Except for the aforementioned blog's heading. [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2008/06/26/identify-empty-cells-in-vba/
Posted
Jun 26 2008, 10:01 AM
by
Daily Dose of Excel