View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neal Steiner Neal Steiner is offline
external usenet poster
 
Posts: 4
Default Fatal Error in Excel with one line in a macro

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