Debugging Excel VBA (F8 is your Friend)

F8 Step Into
Shift-F8 Step Over

The VB interpreter has three states: "NOT RUNNING", "RUNNING", "BREAK". If Excel appears to have frozen, check that the VB interpreter is not hanging in the break state.