In VBA, how do I write an expression that limits BETWEEN to values. For example:
If [Lookup]= 1 to 10 Then msgbox "found it"
The above doesn't work in VBA but this is what I want to do. I want it to look for the values 1 to 10.
How can I make this work?