Named Ranges and Arrays help!

jimijon · Apr 8th, 2002, 06:20 PM

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 · Apr 8th, 2002, 06:35 PM

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))

Apr 8th, 2002, 06:35 PM	#2
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 3,884	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)) __________________ Keep Excelling. Damon VBAexpert Excel Consulting (My other life: http://damonostrander.com )

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 8th, 2002, 06:20 PM	#1
jimijon Join Date: Apr 2002 Location: Chicago Posts: 8	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.