VB_Lover
02-24-2012, 04:50 AM
Hello :)
I wrote a VBA function. It is a lot of calculations (nested loops)
Anyway..
When I change certains cells on the sheet, the cell of my own function is recalcualted auto. (as planned)
My work was on a small size of data but when I increase the data (rows & cols), my function is still working well but slowing
With a change on a certain cell, I should wait more than a minute to see the recalculation result. I need to speed up this code..
However, I don't want to make "much" modification to my code since it contains a lot of "dependent" statments
i.e., any change here needs another change there and so on.. it may result in a lot of maintenance later..
I don't care about the readability of the code..
Many thanks,
VB_Lover
I wrote a VBA function. It is a lot of calculations (nested loops)
Anyway..
When I change certains cells on the sheet, the cell of my own function is recalcualted auto. (as planned)
My work was on a small size of data but when I increase the data (rows & cols), my function is still working well but slowing
With a change on a certain cell, I should wait more than a minute to see the recalculation result. I need to speed up this code..
However, I don't want to make "much" modification to my code since it contains a lot of "dependent" statments
i.e., any change here needs another change there and so on.. it may result in a lot of maintenance later..
I don't care about the readability of the code..
Many thanks,
VB_Lover