Would like my VBA code to run as quickly as possible Any suggestions

Here are a few general tips: Make sure that you declare all your variables. Use Option Explicit at the top of your modules to force yourself to do this. If you reference an Excel object more than once, create an object variable for it. Use the With-End With construct whenever possible. If your macro writes information to a worksheet, turn off screen updating by using Appl i cati on. ScreenUpdati ng = False. If your application enters data into cells that are referenced by one or more formulas, set the calculation mode to manual to avoid unnecessary calculations.

0 0

Post a comment