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

how to save time vba

 

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.

Private Sub Workbook_Open()
Application.Calculation = xlCalculateManual
End Sub

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/