Make your office life easier with simple and fast Excel VBA solutions.
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.
There are variables put inside array. Will variables value change, if array values change?
Watch it here or go to my channel.
Enjoy the video, please leave a like and subscribe!
Is it possible to store for example color property in VBA array? If yes, which approach is faster – array or standard Excel table?
Watch it here or go to my channel.
Enjoy the video, please leave a like and subscribe!
We all know that arrays can store values, for example 2 dimensional array can hold standard Excel table. But can arrays store cell color property?
Watch it here or go to my channel.
Enjoy the video, please leave a like and subscribe!