Macro Speed

  • Thread starter Thread starter mstover34
  • Start date Start date
M

mstover34

I was wondering if anyone knows how to make a macro run faster.

Currently, I run a macro to do a VLOOKUP for 20,000 lines and th
VLOOKUP is getting information from a report that is 50,000 lines long
Every time that I run this macro, it takes almost an hour to run.
This is due to the cells having to be recalculated.

I checked in the options menu and the calculation says automatic so
know that the auto calc can not be the problem.

Overall, if I have to live with waiting for the macro to finis
running, that is what I will have to do, but if there is a way to spee
the macro up and cut down the amount of time that it takes to run, i
would be awesome
 
Do you need it to calc until it is finished? Have you tried turning off
calculation by making it manual. Have you tried it with formulas in each of the
cells, as opposed to running via a macro? It won't be fast, but may well be
faster than what you have now.
 
Back
Top