Download and run the VBA Code Cleaner:
http://www.appspro.com/Utilities/CodeCleaner.htm

Quite likely it will fix the problem.

RBS


"Tom Med" wrote in message
oups.com...
VBA is just about driving me mad... it seems every week now I come
across something new that will cause it to crash. This time it is
when I hit the stop/reset button on the VBA IDE. I have no idea what
is causing it or where to start looking even. Has anyone else come
across this problem, and what might be causing it and how to fix it?

Does anyone know how you can detect why VBA crashes? I seem to have it
crashing if you try and do anything other than simple formatting of
cells. This trial and error then crash and restart style of
programming is the most mind numbing thing in the world.

Is there anyway to debug into the VBA6 dll to find out what the root
of these problems are? I am hitting about 20+ crashes a day at the
moment, and it is driving me mad

Thanks
Tom