Take a look at making a procedure that you can call to assign all your varaibles to an initial value.
Please note that NULL has a special meaning in VB that may not be what you intend...
VBA_Help said:
The Null value indicates that the Variant contains no valid data. Null is not the same as Empty, which indicates that a variable has not yet been initialized. It is also not the same as a zero-length string (""), which is sometimes referred to as a null string.
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.