Hi Worlman1,

Try:

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


---
Regards,
Norman



"Worldman1" wrote in message
ps.com...
another procedure I'm struggling with -

Cell B1 contains a variable cell reference, for example "E:14"
I want to copy contents of cell $E$4 to the cell reference pointed to
in the above

Can't make it work - help would be appreciated . . .

(does anyone know where can I find a comprehensive syntax guide?)

Probably my last question - for now at least . .

Thanks in advance . . .

RonW.