Custos
09-21-2006, 02:01 AM
I have a problem in that i have a series of Vlookup formulas that can be automatically expand to 60,000 lines depending on how many reference cells there are. My problem though is that when Excel calculates all these cells the workbook hangs for quite a while, while processing this data.
Is there anyway to speed up the processing of formulas in excel using VBA? (i.e. like taking out a safety measure then reapplying that safety measure, like Application.ScreenUpdating function.)
Thanks in advance.
Is there anyway to speed up the processing of formulas in excel using VBA? (i.e. like taking out a safety measure then reapplying that safety measure, like Application.ScreenUpdating function.)
Thanks in advance.