Results 1 to 4 of 4

Thread: Fatal error

  1. #1
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Hepler, Kansas, USA
    Posts
    151
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Fatal error

    Regression analysis workbook. When I try to run the regression, I get the following error message:
    Procedure has encountered a fatal error and will terminate. Error code: 516.
    I think this has something to do with vba but I need detailed instructions on how to fix it.

  2. #2
    New Lounger
    Join Date
    Mar 2015
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Always best is to step through the code rather than just run it, see where the code bombs and your know as the lone code will high light yellow are you go

    Post back the code line that fails

  3. #3
    WS Lounge VIP access-mdb's Avatar
    Join Date
    Dec 2009
    Location
    Oxfordshire, UK
    Posts
    1,726
    Thanks
    147
    Thanked 156 Times in 149 Posts
    It would be better to attach all the code with the failing line shown as the error might be caused by a problem in a previous statement.

  4. #4
    New Lounger
    Join Date
    Mar 2015
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by access-mdb View Post
    It would be better to attach all the code with the failing line shown as the error might be caused by a problem in a previous statement.
    Yeah good point

    Also do you just have one module code or are there lots of bit in the workbook, and class codes, and think called from private.xls etc etc theres a few bits to check

    Not sure teh rules here can you post the work book up here (ONLY IF THERE IS GENERIC DATA THAT CAN BE SAFE IN PUBLIC DOMAIN AND CARRYS NO PRIVATE DATA OF ANY SORT TO YOU ? WORK OR ANYONE ELSE - and all responsibility is to the poster for doing so)

Posting Permissions

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