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
http://chandoo.org/wp/2012/03/27/75-excel-speeding-up-tips/
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
Your ads will be inserted here by
Easy Plugin for AdSense.
Please go to the plugin admin page to
Paste your ad code OR
Suppress this ad slot.
Then, a re-calculation can be performed pressing the “F9″ key.
GeSHi Error: GeSHi could not find the language php (using path /home/freepkfv/public_html/wp-content/plugins/wp-synhighlight/geshi/geshi/) (code 2)
4) 13 tips for faster VBA calculations i liked this one. Here is the link you can try by yourself.
http://www.databison.com/how-to-speed-up-calculation-and-improve-performance-of-excel-and-vba/
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.
https://www.soa.org/News-and-Publications/Newsletters/Compact/2012/january/com-2012-iss42-roper.aspx
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/
