Speed up Loop VBA

[PcMax]

Hi,

Performed a test with the macro Sub MarkPositionNumbers3.
Always measured under the same conditions.
I get the following results: 0.125 seconds.

[Rick Rothstein]

Performed a test with the macro Sub MarkPositionNumbers3.
Always measured under the same conditions.
I get the following results: 0.125 seconds.

Thanks for running the test. Admin's Dictionary method is still the winner, but the Collection method I just tried is not that far behind (all those CStr function calls during the loop iterations is what did it in)... at least it was faster than my other attempts, so some progress was made.