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..
@Computergaga6 жыл бұрын
That is great to hear Bernard, thanks.
@Learn_More_Pro6 жыл бұрын
Sir u r giving unique knowledge this is satish from india learn lots of things from you
@Computergaga6 жыл бұрын
Thank you Satish. That is great to hear.
@inderjeetsaini75266 жыл бұрын
this technique was awesome, specially those one with application. it really gives speed to the code. Thanks!
@Computergaga6 жыл бұрын
You're welcome Inderjeet. Thank you.
@dangelmrn37824 жыл бұрын
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.
@scotolivera82074 жыл бұрын
Thanks a lot , very beneficial informations.
@Computergaga4 жыл бұрын
Great to hear. Thank you.
@libraryworld84775 жыл бұрын
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-ev5yh6 жыл бұрын
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
@dilipsanadhya13864 жыл бұрын
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
@Computergaga4 жыл бұрын
I don't have time to check peoples code and fix them Dilip. The video does suggest different ways of reducing the time.