Copy data from a range

[John Wood]

I have data in cells A1:E3. I have a range, within those cells, named 'pets' defined as cells B2:E2. I want to copy and paste that range somewhere else. How do I select that named range in VBA? I know I can't use:

Range.("pets").Copy

 

[Norie]

John

What makes you think you can't use something like that?

The only problem I can see is the . after Range.

 

[John Wood]

I actually got that problem solved AFTER I posted my question. I should have tried harder.

Now my problem is trying to use a validation list, that contains the named ranges of the data I want, to copy and paste another cell.

Private Sub CommandButton1_Click()
'Dim source As Range
Set source = Range("R32").Value
source.Copy
Range("a32").PasteSpecial
End Sub

The validation list is in cell R32 but all this does is copy the word that appears in the list and paste it to A32. I want to used that validation list value AS the range.

Any ideas? I think I'm close but I'm tired, it's been a long day....