F8 allows you to single-step through the macro one statement at a time, and to examine the values of variables at each stage.

Pete