I don't think I've seen excel die with a fatal error on a line like this. (My
code could stop processing, but excel itself keeps running.)

But I don't have a guess either.

I would try Rob Bovey's code cleaner (available from: http://www.appspro.com)
to see if that cleaned up the problem.



Neal Steiner wrote:

Dear Experts,

I have a file in Excel 97 that I have been building for
some months. Yesterday, I added just one line of code
that is Range("xyz")=range("abc").end(xldown). When I ran
the macro, I got a fatal error - excel needs to shutdown.
When I made this line a comment line, everything worked.
When I tried to delete the line, excel got hung up. Any
suggestions on how to fix this or delete this? Thanks in
advance since I do not want to lose the entire file.

Neal

--

Dave Peterson