Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Strange Error Message when trying to insert column

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Posts
    68
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello. In an Excel 97 file, I had copied a worksheet, grouped the two identical worksheets, and then tried to insert a column. I immediately received the following "Program Error" message on my screen: "EXCEL.exe has generated errors and will be closed by Windows. You will need to restart the program. An error log is being created." The file and Excel close automatically. I tried to insert a column in the same file from another PC, and the same error message appeared. The worksheet has external references but no names.

    Questions: How can I determine what the problem is? What is an "error log" and where do I locate it?

    Thank you!

  2. #2
    MrExcel MVP Damon Ostrander's Avatar
    Join Date
    Feb 2002
    Location
    Denver, Colorado USA
    Posts
    4,239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Yepper,

    With this type of problem the log file is generally of no help, except for the Excel developers. This problem is one that the Excel developers didn't foresee occurring and therefore didn't write any error handling or prevention code for it. All that said, in this particular case in which you have described what you are trying to do, I'm virtually certain the problem is because you are applying a paste or insert operation to the grouped set of sheets, and that the problem will go away if you insert the columns into the sheets one at a time (using a For..Each loop, for example).
    Keep Excelling.

    Damon

    VBAexpert Excel Consulting
    LinkedIn Profile http://www.linkedin.com/pub/damon-ostrander/7/79/a93
    AllExperts Profile http://www.allexperts.com/ep/1059-30...-Ostrander.htm

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •