If you are getting this....Use Option Explicit!!!!!!!!!!!!

If you had Option Explicit set VBA would never let the code run in the first place. It would not tolerate mis-spelling....which is the point. The mis-spelled variable would be highlighted and you would get the message "Variable not defined."

Use Option Explicit. It will save you much hair pulling.