Excel cells can't afaik contain NULL. They will be either zero or an empty
string (which behaves like zero in Excel's calculations).

HTH. Best wishes Harald

skrev i melding
oups.com...
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. :)