Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Improving speed with VBA
I am using a series of sumproducts that filter a table of
data based on several criteria (e.g. if field1=X AND field2=Y, etc...) and it would seem to be slowing the file in terms of the recalculation speed. I have turned the spreadsheet to manual calculation as the result. Would writing the code in VBA to do the same thing that I am doing with sumproduct be a performance improvement? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Improving the Discussion Boards | Excel Discussion (Misc queries) | |||
Improving Recalculation Speed for Complex Links | Excel Discussion (Misc queries) | |||
Improving formula | Excel Worksheet Functions | |||
Improving use of Worksheets | Excel Worksheet Functions | |||
need help in improving this macro | Excel Programming |