Speed Up Loop in VBA

Sorry, yes screen updating is off and so are events.

From what i can tell, you are combining the two loops into one and it only performs one thing else another thing. I need it to perform both loops separately because the second one depends on the first loop's changes.

Good question...haha

For some reason, i had it in my head they were dependent on each other. I guess because the way i did it in my head is the way i did it in code and never looked back. I ran it your way and it did seem to cut the time in half.

If i can do this without violating forum rules, i have a second set of loops that also need another eye to look at. I either run the above loop or the below loop depending on the import i am performing. (Last loop i promise)

Please Login or Register  to view this content.

That worked as well. It was missing some data when it went from 100 to 1 so i set it back to 1 to 100 and that did the trick.


Thank you JosephP, that did cut down the runtime some and every second i can shave off definitely helps!