Slow VBA (Vlookup)

[art]

Hello:

I have a problem with a slow VBA code. Actually I don't think it's the code
that is the problem, rather the formulas. I use a list box in a userform to
sort a small list of 14 items. But this in turn causes the formula in the
sheet to update since the list order is changed which is over 28,000 cells,
which in turn causes two columns, each with also over 28,000 rows of formula
to change. Additionally the formulas are Vlookup and I must use the "False"
at the end of the formula, (except if I add to the VBA to sort the whole
column each time, which I think will just add to the wait time).

To change just one item on the list takes over 60 seconds, which is way to
long for me. Is there any way to fix this?

Thanks.

 

[Charles Williams]

Sorting 28000 rows should take a lot less than 60 seconds, so try it and
see.

Presumably you have set Application.Screenupdating to false and
Application.Calculation to xlManual.


Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com