Hi Ron,

Having re-read, your original thread, try changing the contents of cell B1
from

"E:14"

to a valid cell reference, e.g.:

E14

Subject to a valid cell reference in the cell of interest, I had no problem
with my suggested code.


---
Regards,
Norman



"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.