• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Optimize VBA


Excel Ninja
Staff member
In addition to Alan's comments, I assume you mean to optimise for processing speed?

But you may also want to optimise for code length, code readability, CPU utilisation or a number of other measurements of optimisation.
Ok sorry yes I have code for copy and paste data from sheet to sheet based on a column value this happens on 2 sheets (Scheduled and On Site). When I choose option On site or completed from the dropdown and the line moves the process seams sluggish and this is with little data so when i fills up i imagine itll slow down alot more, so really i need speed and memory use optimization