Macros / VBA - stopping

[alfaman]

With sub procedures you can step through them (F8) to see what is happening and Debug.

Is there any way of doing the same with process initiated by a Worksheet _Change sub routine?

I am developing a strategy and had it stepping through each market fine (although the bit to put -8 into cell Q2 to delete closed markets did not seem to work).

I have added green up to this and again it all seemed to go fine.

However, last night , and since then, I cannot get the routine to do anything - it just seems to have stopped resopnding altogether. Is there any way to find out why and has anyone experienced anything similar?

Even going back to previously working versions does not produce any action.

Thought welcomed?

[neeeel]

In the worksheet change sub, in the code window, left click in the margin next to the code, this will place a "break point" ( the line of code will be highlighted in red), when the worksheet change is next triggered, it will stop at the break point, allowing you to step through the code with F8 as before