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.