The main topic seems to be really simple and obvious, but the truth is probably quite different than You could expect. In this article I want to show You how to copy object collection data into worksheet, but faster.
In this video I’m presenting to You three methods, which I’m mainly using in my codes – array as range, loop to array and array as words list. Watch it here or go to my channel. Enjoy the video, please leave a like and subscribe!
After last tests I was not so surprised, but still proud of myself that found the difference between all in one loop and separated. However, I still felt a bit unsatisfied with possibly existing, other solutions and speed up looping performance. That’s why I decided to implement further modification.