• 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

    Hui...

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

Optimize VBA

K

Kurt Smart

Member
Hi all,

I've done some coding but as im a newbie I think its a bit sloppy and the code runs slow could anyone take a look and see where im causing slowdowns please?
 

Attachments

  • Goods In - KPI - Inbound.xlsm
    296.3 KB · Views: 8
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
 
You must log in or register to reply here.
Back
Top