Can anyone suggest a reason why the following fails?

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

Thanks,

RonW.

Try -

Range("b1") = Range("e4").Value

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.

Thanks Nigel, but I need to explain that cell B1 contains a reference
to another cell which is to be the destination of the value in E4. The
purpose is not to copy E4 to B1

If you know how then pls tell me - thanks again , , ,

Cheers,
RonW.

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.

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.

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.

Does B1 contain a valid cell reference? (like C12)

--
AP

"Worldman1" a écrit dans le message de news:
...
Can anyone suggest a reason why the following fails?

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

Thanks,

RonW.

AP, you got it in one - I goofed

I had E:21 in B1, of course it should have been E21

Thanks to everyone for your kind assistance :-)

Cheers,
RonW.