Nope, that is not what I meant. The OP said this...

1) I have a cell which i have named "ExtraRisk".

2) This cell contains text : example "Electricity", which is
also the name of a range.

3) Now i want to select this named range "Electricity" &
copy the range

Numbers 1 and 2 tell me that the contents of Range("ExtraRisk") is the word
Electricity and that Electricity is a named range. Number 3 says the OP
wants to copy Range("Electricity"). Since Range("ExtraRisk") contains the
word "Electricity", we can do a direct substitution, putting
Range("ExtraRisk") in place of the word "Electricity"; hence
Range(Range("ExtraRisk")) points to whatever the named range "Electricity"
points to; so, according to Number 3, we want to copy that...

Range(Range("ExtraRisk")).Copy

I guess the only thing this expression can be faulted for is relying on the
default value of the Range object; perhaps this would have been more to your
liking...

Range(Range("ExtraRisk").Value).Copy

--
Rick (MVP - Excel)


"michdenis" wrote in message
...
Hi,

you mean this : Range(Range("ExtraRisk").address).Copy



| If I understand you correctly, I think you want this...

| Range(Range("ExtraRisk")).Copy

"