Hi all,
I am doing a vlookup on loop and it is taking a long time to cycle through 20,000 rows. I am new to arrays, dictionary etc so looking for some guidance on this one.
Much appreciated.
Here is the code that works fine albeit slow along with some sample data:
Sub test()
Dim rng...