I am ruing the same piece of VBA code in Excel in two different ways. 1. Original way: click a command button which calls the sub. 2. Call the sub from a macro in a different workbook by using Application.Run.
I put a timer to measure how long it takes to run only the code in the sub. For the first way, the time taken is 319.36 seconds while for the second way the time taken is just 2.89 seconds.
How can this be explained?