Results 1 to 2 of 2

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

Threaded View

  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.

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. 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