LinkBack URL
About LinkBacks
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?
Columns("A:A").insert
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?
Columns("A:A").insert
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
Register To Reply
Bookmarks