[Performance] Transferring data from a cell from sheet1 to another cell on sheet2

Good morning everyone,

I have a question regarding the performance of this 3 ways to move a specific data from a cell to another cell

The first method that i have is this one

Please Login or Register  to view this content.

The second method would be this one :

Please Login or Register  to view this content.

And the last one, in my opinion ,the slowest one

Please Login or Register  to view this content.

My questions is :
What is the best way (faster times / low resource consumption) to copy a cell value to another sheet in a specific cell?

Thank you for your time,
Alex

There is no best, but the second one is fast, but limited by copying values only. The last one is the slowest as it has to do more work by selecting, copying and pasting.

Why not write a simple loop to time this? It's not an accurate measure but will give results you can compare to see which is fastest.

Please Login or Register  to view this content.

The loop is there only because you would have a difficult time trying to get a time for one copy - but the second option would be fastest. Sending stuff to the clipboard is relatively slow.

Hey,

Thanks a lot for the timer idea.

Here is my response with the results:
Copying from a sheet to another sheet from 1 to 1000 using this text in the cell "test_Test_test_test_test_Te" has the following times :

Please Login or Register  to view this content.

5.730469 seconds

Please Login or Register  to view this content.

0.015625 seconds

Please Login or Register  to view this content.

NOTE : This has a lot of windows flickers! not recommended

4.4375 seconds



Thanks for your time!
Alex

I know about turning off screen updating by using that code, but from my experience that will go ugly very quick when someone updates the macro / modifies something.

Please Login or Register  to view this content.

OK - is just something I've used without problem for yonks