IS NULL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HI,
the if statement not execute .

the code:
v_checkvalue = xlRng.Value

If IsNull(v_checkvalue) = true Then
MsgBox "null" & v_row & ""
GoTo nextrow
End If

even when the value is null this code not working.

thanks.
 
Are you sure your value is null?

There is difference between Null and "".

Perhaps this would work in your case
v_checkvalue = xlRng.Value

If IsNull(v_checkvalue) = true or v_checkvalue="" Then
MsgBox "null" & v_row & ""
GoTo nextrow
End If
 
In
SIN said:
HI,
the if statement not execute .

the code:
v_checkvalue = xlRng.Value

If IsNull(v_checkvalue) = true Then
MsgBox "null" & v_row & ""
GoTo nextrow
End If

even when the value is null this code not working.
Click to expand...

Is v_checkvalue a Variant? If it is, and the MsgBox statement isn't
executed even when you *think* the value is Null, then I suspect the
value isn't really Null. There are other possible "blank" values that
aren't Null. Maybe it's a zero-length string, or even Empty, instead.

Set a breakpoint in the code, at the If statement. When it stops there,
let your mouse pointer hover over v_checkvalue, and see if the tooltip
tells you that the value is something other than Null.
 
Back
Top