Named Ranges and Arrays help!

[jimijon]

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.

 

[Damon Ostrander]

Hi Jimijon,

You must use the Set keyword because a range is an object, and myRange is therefore a Range object variable. So...

dim myRange as Range
Set myRange = Range(myArray(i))