calculations on vlookup during a macro

[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

 

[Dave Peterson]

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

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