Need Help
I am trying to set a variant to be public. My code would look
something like this.
Option Explicit
Public vOptionLookup as Variant
________________________________________
Sub SetVariables ()
vOptionLookup = Application.VLookup(rItem, rItemsInfo, 37, False)
End Sub
_________________________________________
Sub OptionLookup()
Application.Run "SetVariables"
Range("A1").Value = vOptionLookup
End Sub
The problem is that in the help file it says Variants are not
supported to be public, which I found to be true. Is there a work
around or something I can do to make this Variant public so I can use
it in several different places?
Any input would be awsome. Thanks.
|