This can mean that what should take a matter of 1 to 3 seconds, often takes a lot longer. Free Excel Help One drawback with recorded macros in Excel is that the code produced is often very inefficient. This can happen with recorded macros that have the word Select used frequently. If this does happen, you may need to repeat the line: Application. This page lists some suggestions and strategies for optimizing your Visual Basic For Applications (VBA) code, so that it will run faster. There are few absolute rules for optimizing VBA; you'll see the best increases in performance by streamlining the basic logic.
|