| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
| cells formatted to tick when text value "Y" if or null if "N" | Excel Discussion (Misc queries) | |||
| "IF"- "THEN" type Formula based on Null value | Excel Worksheet Functions | |||
| empty vs. "" vs. Null vs. Nothing vs. not Used vs. Argggh | Excel Programming | |||
| Looking for VB code to test for "RING" , "BUSY" disconnects or other signals | Excel Programming | |||
Threaded Mode
