| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible syntax error
Can anyone suggest a reason why the following fails?
Range("E4").Copy Destination:=Range(Range("B1").Value) Thanks, RonW. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Possible syntax error
Try -
Range("b1") = Range("e4").Value |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Possible syntax error
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Possible syntax error
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Possible syntax error
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. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Possible syntax error
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. |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Possible syntax error
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. |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Possible syntax error
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. |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Possible syntax error
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| runtime error: syntax error or access violation | Excel Programming | |||
| runtime error: syntax error or access violation | Excel Programming | |||
| variable not declared error & syntax error | Excel Programming | |||
| Syntax error. | Excel Programming | |||
| Syntax Error Runtime Error '424' Object Required | Excel Programming | |||
Linear Mode
