Macro that recognises cell value as a range name

[arod]

I am trying to get a macro that will recognize the text in a cell as a reference to a range name and then perform actions to this range.
For example:
• In A1 I have the text ‘Range1’
• ‘Range1’ is a named range referring to cells A2:A5
• I am currently using the code:
Range(“Range1”).Select
Selection.Copy
• This only selects A1 rather than actually selecting A2:A5

Does anyone know how I can get this to work?

Thanks

 

[ajm]

try:

Var = Range("A1").Value
Range(Var).Select
Selection.Copy

where VAR is any variable name or letter that you want to use

 

[arod]

Thanks – that did the trick.

 

[ajm]

first thing: spelling mistake "coutner" instead of Counter?? and secondly, what are you trying to count and can you give an example of the data and the situation in which this code would be used?

 

[mikerickson]

If you enter a name in the Name Box (the one to the left of the formula box) and press enter, you will select that named range. No macro is needed.