calculations on vlookup during a macro

  • Thread starter Thread starter Kenlyn
  • Start date Start date
K

Kenlyn

I have a macro the does a vlookup from a different worksheet in the
same workbook. It is a large file, 50,000 rows. After the vlookup is
complete, I insert columns next to the results of the vlookup and the
insertion causes the vlookup to re-calculate and it slows the macro
down. All I am doing is inserting a few columns. Is there a way to
make that part of the macro speed up, but not continually
re-calculating.

I know that I can paste values and then delete the vlookup column with
the formula. Was wondering if there was another way.

Thanks.

Kenlyn
 
Maybe insert your columns before you apply the formula???

Maybe turn calculation to manual until you want it turned on for real??
 
Back
Top