Looping performance 2 – can I speed it up?

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.

Looping performance 2 - can I speed it up pyjama kid
Continue reading “Looping performance 2 – can I speed it up?”

Video tutorial: Store color property – array vs table speed comparison

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!

Video tutorial: Arrays as best Excel table alternative!

Arrays are awesome. This is one of the main things You should learn working with Excel VBA. In case of data, I think I can safely say, that arrays are the best alternative for tables in VBA. Watch it here or go to my channel.
Enjoy the video, please leave a like and subscribe!