How to speed up my code

 Trowa -

Let me start by posting my workbook:

When you go to sheet "Alle opdrachten" you will see red and green lines. When you click the button "Voltooide opdrachten afvoeren", the green lines will be moved to the next sheet "Voltooide opdrachten".

When I first implemented the code (credit goes to Rizvisa) everything was working smoothly. But now, after adding more codes to the workbook, it takes forever.

What are my options for running the code faster? Do I need to cut something out?
Please advise?

Best regards,

1 reply

Registration date
Thursday January 28, 2010
Last seen
August 2, 2020
Your issue are the events. As the code is running, all sort of events are fired up
and Selection_change etc

Now I dont know if you do want the code to fire these events as macro is running or do you want to do it if the user does some thing.
If you want to disable events while code is running, you can add a line

Application.enableevents = false

and once the code is done running, add
application.enableevents = true
Thanks Rizvisa, exactly what I needed. Code is running smoothly again.

Kind regards,