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

Thread: Critical Failure in Compling a Macro

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have been creating some Macros in Excel and when I select compile from the debug menu I get the windows message "This program has preformed an illegal operation and will be shut down."

    Does anybody know what could cause this. I have tried deleting bits of the macros to try and identify what is causing the error but to no success. Any suggestions would be greatley recieved.

    regards,

    Jon

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    2,940
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    I think everyone who has used Excel for a while has come across this message (and wanted to throw their PC across the room when they've lost an hour of unsaved work )). I've never come across it when using Debug, Compile. I think the best thing to do is post all of your macros so someone else can try it on a different machine. That should help start eliminating potential problems.

    Regards,
    Dan

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    England, UK.
    Posts
    526
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    i have never had it on excel, but have had it with internet explorer a LOT!!

    RET79

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
  •