How to speed up my code
Solved/Closed
Related:
- How to speed up my code
- Need for speed most wanted 2005 - Download - Racing
- Blackmagic disk speed test windows - Download - Diagnosis and monitoring
- How to get whatsapp verification code online - Guide
- Need for speed unbound free download - Download - Racing
- Samsung keypad reset code - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
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