Use Named Range as indicated in a cell

Hello,

I am using a dropdown menu which gives a list of named arrays to allow people to choose which set of values they wish to look at below. These values will be pasted in using VBA. I want VBA to copy the named array. when i put in:

Range("myArray").Copy

it copies fine. but if i do this:

Range("B2").Copy

It only copies "myArray."

Does anyone know a way I can reference my cell and then copy the array based on the name in the cell?


Thanks a bunch!

Hey,

It looked good. but now i am getting "Range of Object _Global failed."