Some good coding habits can keep your workbook calculations work faster,so i am sharing here some of the excel sources that will allow you to save time next time.
1)Avoid reading values cell by cell from a spreadsheet – Read/write in bulk
here is an example set
2)From chandoo – 75 different tricks that users have submitted ..quity handy
3) Avoid autocalculations during VBA code is executing. You can use this code to avoid any auto calc in vba
how to do it
File->Options->Formulas >> calculation options
Then, a re-calculation can be performed pressing the “F9″ key.
4) 13 tips for faster VBA calculations i liked this one. Here is the link you can try by yourself.
5) Turn off screen updates : It can be achieved by this command
Following command turns off screen updates.
Application.ScreenUpdating = FALSE
6) Some functions do slow VBA so better avoid them for eg Min(), Max(), Average(), Match(), here is a guide where the blogger tells us how he had written some of these functions and how faster they are along with some more (11) tricks.
7)Substitute your slow UDF by a call to Theta Proxy .. here is the guide http://computeraidedfinance.com/2012/01/16/how-can-i-speed-up-my-ms-excel-sheet/