I would recommend commenting out the "on error" line completely. The breakpoints are a fine idea but you won't even need those if you comment out the "on error goto" line completely. Then the code will go into debug mode directly on the line where the error is. Once that happens, click Debug. Then view the Immediate window (View, Immediate window), and you can start practicing some of the debugging techniques (such as asking the immediate window a question, such as ?varname.value (and hit Enter) ........ FWIW