Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Difference between value.empty and value.""
- Thread starter MuskyMan
- Start date
Whilst if cell.value = "" will pick up empty cells, it'll also pick up cells with a formula that returns "" like
=if(A1="","","Blah Blah"
If you want to pick up truly empty cells only, use ISEMPTY ie
If ISEMPTY(range("A1") then
msgbox "Empty"
else
end if Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde
=if(A1="","","Blah Blah"
If you want to pick up truly empty cells only, use ISEMPTY ie
If ISEMPTY(range("A1"
) thenmsgbox "Empty"
else
end if Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question