hOW DO I INCREASE MY MACRO RUN TIME ? I HAVE A LOT OF VLOOKUPS

C

chinedum obianwu

I created a macro that looks up an id in a different worksheet using
vlookups. The problem is that i have a lot of rows (over 3000) that are
utilizing the vlookup formula and each time i run the macro, it takes very
long to to populate the values. I tried embedding the vlookups in the macro
rather than on excel, but that did not help any. How can i make the macro
run a little faster ?
 
E

Eddie Holder

In VB, you could
a) swith of screen updating aplication.screenupdating=false
b) switch off the autocalculate function in excel and turn it back on when
done
Application .Calculation = xlManual or (Automatic) then add a line to
calculate the sheet when the macro is completed. Simply add the word
"calculate"

This should speed it up a bit.
 
Top