Hi
if you only need the values I'm quite sure the first one is faster

--
Regards
Frank Kabel
Frankfurt, Germany

"Marcotte A" schrieb im
Newsbeitrag ...
I believe option one is faster. Can anyone confirm? The goal is to
copy a
value from one cell (in one workbook) to a cell in another workbook.

1)
myrange1.value = myrange2.value

2)
myrange2.copy
myrange1.paste

(Note: I know the above code is incorrect syntax, but I think you get
the
idea of what I mean.)