I have need an array filled with constants to run a macro of mine. Is there any way to assign multiple values to an array in a single statement. It might look something like this :
Dim MyArray as String
MyArray = ["Value", "Value2", "Value3"]
I'm pretty sure you can do it in other languages but I'm not sure about VBA.
Thanks,
Rick
Dim MyArray as String
MyArray = ["Value", "Value2", "Value3"]
I'm pretty sure you can do it in other languages but I'm not sure about VBA.
Thanks,
Rick