my worksheet change even keeps stopping for range (B10:B47). I added "Application.EnableEvents = True" into my code but it still stops. When it stops I run the below code with that in it and it works again. Do I have it placed into my first code correctly or what need to be changed
when I run this it starts to work again
Please Login or Register to view this content.
Please Login or Register to view this content.
Put a break point at the beginning of the code.
Trigger the change event and step through line by line and I'm sure you will see that after it's set to false the code is not running a line that sets it back to true.
I am not sure how to do what you are suggesting
some light reading on vba debugging
https://www.techonthenet.com/excel/m...kpoint2013.php
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Setting a breakpoint.
Set a break point on the first line of code, then when the code is triggered it will stop on the first line.
You can then step through the code line by line by continuously pressing F8.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks