Range Name in Macro

[MikeG]

I wonder if anyone could help.

I have several range names in a worksheet, and they are of the form Quote_Type1, Quote_Type2, etc.

I also have a range called Selected_Quote where the use enters the number of the quote they are interested in.

What I want to do in the macro is copy the relevent Quote_Type range, based in the Selected_Quote.

Is it something like:

Name ="Quote_Type" & Range("Selected_Quote")
Name.Copy

Thanks,

MikeG

 

[njimack]

Name = Range("Selected_Quote").Value
Range("Quote_Type" & Name).Copy

 

[MikeG]

Name = Range("Selected_Quote").Value
Range("Quote_Type" & Name).Copy

Thanks Neil!

 

[Rick Rothstein]

The argument to Range is just a String, so you can concatenate that argument together from whatever text parts you want...

Range("Quote_Type" & Range("Selected_Quote").Value).Copy