Whenever I insert a Column (or delete) in my VBA code it runs extremely slow. Other code that seems way more complicated seems to run much quicker. Is there a way that I can program this differently so that it runs faster?
Please Login or Register to view this content.
Hard to say definitively without knowing more detail.
Here are some general tips to make code run faster.
Optimize Slow VBA Code
The Application.ScreenUpdating=False tip could be a major improvement if you are looping several column inserts. Or if you have a lot of formulas, you may want to temporarily set the Calculation Mode to manual.
Last edited by AlphaFrog; 04-10-2013 at 04:26 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks