+ Reply to Thread
Results 1 to 2 of 2

VBA Application-defined or Object-defined error on an unknown line of code.

  1. #1
    Registered User
    Join Date
    07-06-2012
    Location
    Kingston, Canada
    MS-Off Ver
    Excel 2007
    Posts
    21

    VBA Application-defined or Object-defined error on an unknown line of code.

    Hello Everyone,

    In the past when I have run into an error, VBA would stop and allow me to debug and it highlights the line where the error is occuring. In this case it does not provide the line of code that is causing the error and therefore I cannot determine what is the causing the error.

    I have attached a copy of the workbook with the two subroutines that I know the error is located within uncommented (all other subroutines require access to a separate program), whereas these two only use Excel. The excel solver (not on by default) is used in the Crack Analysis code.

    The Crack Initiation button runs through the code once and stops. However, clicking on this button does not provide me with an error. The crack growth button is meant to iterate through by the number in the interations cell by calling Module 1.

    The error is returned by the following block of code (which is used to capture errors), but the line of code is not provided for debugging purposes.
    Please Login or Register  to view this content.
    Does anyone know how to determine which line of code the Application-defined or object-defined error is occuring?
    I would really like to know what could be causing this error only when the iterative button is pressed.

    Regards,

    Kyle
    Last edited by kyleg222; 07-27-2012 at 10:18 AM.

  2. #2
    Registered User
    Join Date
    07-06-2012
    Location
    Kingston, Canada
    MS-Off Ver
    Excel 2007
    Posts
    21

    Re: VBA Application-defined or Object-defined error on an unknown line of code.

    I captured the error that I was trying to solve.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1