Test for Empty, Null, "", 0
TIA:
I am testing for contents of a cell (the data was imported from Access to
excel). The worksheet cell looks blank (no data) but when I test
IsEmpty in False and IsNull is False and cell="" is False
I see nothing but every test tells me something is there. If if test not Is
Empty is True.
If I test cell = 0 if get mismatch of data type (the field is Date format)
HELP...Thanks,
Joel
|