Quote Originally Posted by frank_m
Try again Aflatoon's suggestion in post#2, except after you Delete the Form and choose "yes" to export a copy, be sure to:
(1) save the new version of your workbook (that no longer has the Form)
(2) close the workbook.
(3) reopen
(4) import the backed up copy you made of the Form.
(5) save that workbook version (that now has a new clean copy of the Form and it's code)
(6) try running your procedure
Thats exactly what i did. To be sure though i tried it again now.. still messes up.

Also, this code cleaner, i am going to search for it and give it a try. As its been a loooooong time since i have done vb and its showing haha. my codes pretty messy.