Well, first off, I'm wondering if you have cleaned your
code . . . and I am saying that because I had a similar problem
(when I was trying to make a macro pretty much bombproof) which made
me work hard to figure out why a subroutine crashed when I had been
stepping thru it line by line and it crashed at a point where there
was no code showing in the VBA editor. I've become a bit obsessive
about backing up and cleaning the code I write since then, but
perhaps that's not simply a mental disorder (heheh, I hope). I
have used the freeware code cleaner found at:
http://www.appspro.com/Utilities/CodeCleaner.htm
and I have also just copied the text version of the code out to a
textfile and back . . . both seemed to be the same so I have
continued to use the AppsPro code cleaner successfully.