Try using Debug.Print in your code to "print" Immediate window what is
going on as your code runs.

The Debug.Print dialog never appears, and the code has stopped falsely
reporting that exception condition in the data being processed. I put it
right after the statement that assigns the exception message to a string
variable.

If I watch the code, again, it doesn't mess up. What is this, quantum
programming? ;-)

I closed and reopened the file with all this code in it, re-ran the code
with the watch still there, deleted the watch and hit F5. After that, the
code ran fine -- no rewriting needed. It's like kicking a cantankerous
machine and having it start working again. Oh well.

Gregg Roberts