How do you deal with a function returning a null value? I know PL/SQL has a function nvl() that can put something in place of a null if null is returned. Does VBA have anything like that?
or Nz(variant[, valueifnull])
You can use the Nz function to return zero, a zero-length string (" ", or another specified value when a Variant is Null. For example, you can use this function to convert a Null value to another value and prevent it from propagating through an expression.
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.