6 Ways to Speed up your Excel Macros

[@bernardblumberg803]

I have very long macros that show all that you mention.. This is a sensational video. You've saved me many minutes, THANK YOU Mr Gaga..

[@Computergaga]

That is great to hear Bernard, thanks.

[@Learn_More_Pro]

Sir u r giving unique knowledge this is satish from india learn lots of things from you

[@Computergaga]

Thank you Satish. That is great to hear.

[@inderjeetsaini7526]

this technique was awesome, specially those one with application. it really gives speed to the code. Thanks!

[@Computergaga]

You're welcome Inderjeet. Thank you.

[@dangelmrn3782]

interesting points ,if anyone else trying to find out best app to clean mac try Elumpa Speedy Mac Alchemist (do a google search ) ? Ive heard some great things about it and my co-worker got amazing results with it.

[@scotolivera8207]

Thanks a lot , very beneficial informations.

[@Computergaga]

Great to hear. Thank you.

[@libraryworld8477]

to Hello Sir I am Working with two Workbooks with Looping Process. For Example (For i = 8 to 20) I use all the methods but my macro still Take a time of 8 Seconds.

[@LM-ev5yh]

Option Explicit Sub SpeedUpMacros() Dim i As Long Dim TotalRows As Long Dim CatRow As Long With Application .Caculation = xlCalculationManual .ScreenUpdating = False .DisplayStatusBar = False .EnableEvents = False End With i = 2 TotalRows = Application.CountA(Worksheets("Sales").Range("A:A")) Worksheets("Sales").Select Do While i

[@dilipsanadhya1386]

Hi ... I have facing some issues to run the micro it's take long time to execute. Please suggest and give mail id give this file to check this code

[@Computergaga]

I don't have time to check peoples code and fix them Dilip. The video does suggest different ways of reducing the time.

[@dilipsanadhya1386]

Thank you for reply

[@MyMomSayNoDota]

hah. so many codes to repair.. thanks!

[@Computergaga]

My pleasure, Fariz.