What is the syntax to put a range in a variable from an array of names?
I have an array where I am storing the names of certain ranges, now I want to use them, I can't figure out how to do it!!
dim myRange as Range
myRange = Range(myArray(i))
The above won't work?! myArray is a string array and i could be 1 here. What is the proper syntax.
I have an array where I am storing the names of certain ranges, now I want to use them, I can't figure out how to do it!!
dim myRange as Range
myRange = Range(myArray(i))
The above won't work?! myArray is a string array and i could be 1 here. What is the proper syntax.