+ Reply to Thread
Results 1 to 2 of 2

Error handling not working........ Working on First error instance but not on 2nd instanc

  1. #1
    Registered User
    Join Date
    07-19-2019
    Location
    USA
    MS-Off Ver
    office 365
    Posts
    29

    Error handling not working........ Working on First error instance but not on 2nd instanc

    PLEASE IGNORE THIS.............I GOT IT

    Error handling working for the 1st instance but not for the 2nd instance. Exactly same code is used. Please see the debug screenshot with comments.

    There are 3 Arrays.

    Array 1 -> Array_common
    Array 2 -> Array_In_OnenotTwo
    Array 3 -> Array_In_TwonotOne

    Array 1 --> NOT BLANK.
    Array 2 --> BLANK.
    Array 3 --> BLANK.

    My aim was to find number of elements in each array and i thought of looping the array using UBOUND.

    Array 2 --> Since its blank , it successfully goes to the tag ERR2.

    Array 3--> Since it is blank, it shall goto tag ERR 3. But instead it gives error "Subcript out of range".

    If array handling at Array 2 is working why not same code ar Array 3 working ??

    weird issue 2 - array length.png
    Last edited by enggrahul78; 07-19-2020 at 11:59 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Error handling not working........ Working on First error instance but not on 2nd ins

    Quote Originally Posted by enggrahul78 View Post
    PLEASE IGNORE THIS.............I GOT IT
    Since your problem description was so thorough, could you share your solution so if someone with a similar problem finds this in a search they might get some hints?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Error handling not working in "vba object variable or with block variable not set" in Loop
    By caabdul in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-23-2019, 06:40 PM
  2. Error Handling not working
    By no1uno in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2017, 10:20 PM
  3. Runtime Error 53 On error resume next not working
    By KevBotes in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-01-2016, 11:07 AM
  4. Getting Run-time Error 91. Error handler not working.
    By rbs123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-13-2014, 04:20 AM
  5. Unusual error-handling results in previously working code written for Excel 2002
    By guindi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-23-2007, 02:27 PM
  6. [SOLVED] Error Handling - On Error GoTo doesn't trap error successfully
    By David in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-16-2006, 02:10 PM
  7. [SOLVED] error handling not working
    By Mike Macgowan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-14-2005, 06:06 PM

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