Forum Discussion
Excel Macro Runs *PAINFULLY* Slow
I have an issue running an Excel Macro. I have read a lot of threads and tried all of the suggestions but no change in performance. I have run the same file/macro on 2 machines, details below. No mat...
you are right Macros do run slower in general. usually you cant see what the Macro is doing. Now it seems you can pretty much watch it go play by play.
So far, everyone has missed the point. The. Same. Macro.. running the. Same. Data.. on the. Same. OS. BUILD.. (i.e. Windows and Office 64-bit) runnings much, much, *MUCH* slower on the newer machine that is far superior in all regards.
I’m not looking for advice on how to run the macro more efficiently or alternative methods to macros, I’m looking for help to speed up my machine the should have run far faster out of the box.
I’m not looking for advice on how to run the macro more efficiently or alternative methods to macros, I’m looking for help to speed up my machine the should have run far faster out of the box.
Hershner04You are not alone. I have the same situation and I am fed up with Microsoft making excuses for things like this. The macro I am having the problem with has nothing but simple copy statements between cells on one sheet and cells on another, along with some formatting. With Excel 365 is is managing to copy around 1 cell per second. Can somebody please explain how that can possibly be bad code on my part.
