Thread: Possible syntax error
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Ardus Petus Ardus Petus is offline
external usenet poster
  
Posts: 718
Default 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.



Reply With QuoteReply With Quote