I wrote a macro to test inserting a blank row after rows containing certain items. I tested this alone and it went fairly fast for the computer I used it on (an older computer that you can see every move on). I then added the code for this to the end of a larger macro that is run. The time it takes to run just the insert rows part (after the rest of the macro is completed) is much longer than the time it took to run the same code when it was in its own macro.
Why does it get slowed down when placed after other code? Instead of one large macro would it be better to write a bunch of smaller macros that get called by one common macro?
Thanks!!!
Why does it get slowed down when placed after other code? Instead of one large macro would it be better to write a bunch of smaller macros that get called by one common macro?
Thanks!!!