I allways had problems with the IsNull function as it will return False if it is empty so one would have to check for IsEmpty etc. all this checking became borring, so I use this little function:
Function IsBlank(V As Variant) As Boolean
On Error Resume Next
V = "" & V
If Len(V) = 0 Then IsBlank = True
End Function
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.