| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Null, "null", vbNull, vbNullString, vbEmpty
Hi,
if I am writing VBA code in MS EXCEL to insert 'nulls' into certain cells, so that when I import that into MS Access I can run queries with the filter criteria such as SELECT * FROM blah WHERE column Is Not Null Then which Null do i use? cell.Value = Null ? cell.Value = "Null" ? cell.Value = vbNull ? cell.Value = vbNullString ? cell.Value = vbEmpty ? I'm all nulled crazy ...hehe. :) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperion Essbase Excel Add-in - returning text ("0") for null valu | Excel Discussion (Misc queries) | |||
| OTHER options for chart not plotting null ("") or zero values | Charts and Charting in Excel | |||
| How to write parameter query with "or is null" criteria | New Users to Excel | |||
| 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 | |||
Threaded Mode
