Which is faster code...
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.)
|