How to speed up my code
Solved/Closed
Related:
- How to speed up my code
- Blackmagic disk speed test windows - Download - Diagnosis and monitoring
- Google maps speed cameras - Guide
- Huawei test code - Guide
- Care code 205.2 lu003 - Yahoo Mail Forum
- How to get whatsapp verification code online - Guide
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Jul 23, 2010 at 06:09 PM
Jul 23, 2010 at 06:09 PM
Your issue are the events. As the code is running, all sort of events are fired up
Worksheet_Change
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
Worksheet_Change
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
Jul 27, 2010 at 08:55 AM
Kind regards,
Trowa