When debugging, comment out On Error lines of VBA code.

In the VBE, in a routine use F8 to step through code one line at a time.

Use Debug.Print to print variable contents to the Immediate window.