Need help empty Integer?

[Sorwen]

Most times I don't mind VBA. It works fine, but others it drives me up the wall. What do I do to check for an empty integer variable? Null, Empty, Nothing all only work if the data type is the annoying Variant Data Type. What Can I use? (Side note for a interesting idea Variant is more of a headache than it is worth IMO.)

 

[PHV]

check for an empty integer variable
Only Variant can be Empty (or Null).

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[rmikesmith]

Adding to PHV's comment,

An integer without a specific assignment defaults to 0.


Regards,
Mike

 

[Sorwen]

Thanks. I was just coming back. It was the way I used empty was the problem. Thanks.