Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Slow VBA (Vlookup)
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Slow VBA (Vlookup)
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 "art" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Slow Tab | Excel Discussion (Misc queries) | |||
Very Slow | Excel Programming | |||
VERY SLOW | Excel Discussion (Misc queries) | |||
Slow Excel Navigation with Up / Down Arrow and slow scrolling | Excel Discussion (Misc queries) | |||
Why Del is Slow | Excel Discussion (Misc queries) |