Code unable to debug, how to run continuously?

Put the word Stop as the first line of code in the Change event handler. Then, when you make a change, it will stop and you can use F8 to step through the code.

Regards, TMS

Please Login or Register  to view this content.

If you have a Worksheet Change event handler, such as your code, it will fire for EVERY change made on the worksheet. It's then up to you to decide whether or not you are interested in the change that has been made. And, if you are, what do you want to do about it.

So, yes, the Worksheet Change event handler will (does) run continuously but, for diagnostic purposes, the Stop statement will halt execution so that you can step through and see what is happening. However, what IS happening is that for each and every change made to ANY cell on the worksheet, the event will fire and check the values of certain Named Ranges. It will then hide or unhide specific rows.

The code looks a little repetitive and not very scaleable but I'm sure it does what you want.

Regards, TMS

You're welcome. Thanks for the rep.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.