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.Continue reading “Looping performance 2 – can I speed it up?”
Tag: how to increase performance of loops in vba
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?Continue reading “Looping performance – all in one or separated loops?”