Posts

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?”

Looping performance – all in one or separated loops?

Recently I was working on complex tool, which was doing some actions on Excel cells. In some cases it took a while to process whole example data workbook. Thinking how to speed up the code I asked myself what will be better in case of looping performance – all procedures in one loop or all in separated loops?

Looping performance - all in one or separated offspring
Continue reading “Looping performance – all in one or separated loops?”

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!