+ Reply to Thread
Results 1 to 3 of 3

In case Run-time error '13' do this...

  1. #1
    Forum Contributor Gabor's Avatar
    Join Date
    02-15-2004
    Location
    Székesfehérvár, Hungary
    MS-Off Ver
    xl2016
    Posts
    226

    In case Run-time error '13' do this...

    I'd like to bypass certain steps in case type mismatch occurs.
    How do I go about that?
    Funny thing is once this has happened certain macros do not run again until I turn Excel off completely and restart.
    Closing the workbook does not help. MS-Excel must be turned off. Is it normal? (Excel 2003)
    One variable stores Error 2023 and then some comparisons in the code start to fail.
    Any clues?
    Thanks
    Gabor

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,481
    Quote Originally Posted by Gabor
    I'd like to bypass certain steps in case type mismatch occurs.
    How do I go about that?
    Funny thing is once this has happened certain macros do not run again until I turn Excel off completely and restart.
    Closing the workbook does not help. MS-Excel must be turned off. Is it normal? (Excel 2003)
    One variable stores Error 2023 and then some comparisons in the code start to fail.
    Any clues?
    Thanks
    Gabor
    Hi,
    Could you post the code?

  3. #3
    Forum Contributor Gabor's Avatar
    Join Date
    02-15-2004
    Location
    Székesfehérvár, Hungary
    MS-Off Ver
    xl2016
    Posts
    226
    Difficult, since the code is very, very big and fuzzy, so I better explain it with words:
    This is an excel-based Gantt chart.
    CommandButton on the sheet offers the opportunity to the user to delete a task-line in the Gantt-chart.
    So the problem occures when the user deletes a task-line where the End-date is used by another Task-line to be the Start-date. So since the Start-Date is a Formula e.g. '=G9'. So in case the row 9 is deleted some formulas that are responsible to calculate min and max dates on the chart turn to #REF! and macros that would want to use the entries of these cells will not be able to perform the required calculations.
    In a nutshell this is the layout of the issue.
    Actually I was buffled by the fact once the problem occured excel did not want to run some of the codes even after I have corrected the error on the sheet.
    Not sure this makes the problem any more understandable.

    Cheers, Gabor

+ 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