Sorry, I read this literally as a value copy not a reference copy!

--
Cheers
Nigel



"Norman Jones" wrote in message
...
Hi Nigel,

Because syntactically it is wrong!.

Are you sure?!

See Ron's original thread and my response to Ron in this thread.

http://tinyurl.com/qvsej


---
Regards,
Norman



"Nigel" wrote in message
...
Because syntactically it is wrong!.

Try using......

Range("E4").Copy Destination:=Range("B1")


--
Cheers
Nigel



"Worldman1" wrote in message
oups.com...
Can anyone suggest a reason why the following fails?

Range("E4").Copy Destination:=Range(Range("B1").Value)

Thanks,

RonW.