Ignore Subscript Out of Range Error

Hello,

I am writing a binary search function. At the end I check to see if the next element matches the "search for" value. When searching for an element larger than any in the list, my marker lands on the last list element and I get a "subscript out of range" error when trying to check the non-existent next element. To me, if there is no next element then obviously it can't be equal to the value, so the if condition should fail and it should move on to the next line of code. Unfortunately, even when I put "On error resume next" it still gives me the error. How can I ignore the error and move on as if it was false?

My code segment (inArr is the list to be searched, Match is the marker, val is the "search for value, gap/run are options):

Please Login or Register  to view this content.

This gives me an error if Match>UBound(inArr,1) despite the On Error Resume Next.

Instead of On Error Resume Next, test if Match is less than the Ubound of the array.

Please Login or Register  to view this content.

Thanks AlphaFrog,

That should work for this situation. For the future, is there a way to ignore Subscript Out of Range?

Originally Posted by k64

Thanks AlphaFrog,

That should work for this situation. For the future, is there a way to ignore Subscript Out of Range?

I'd have to see the whole procedure to better understand how the variables are declared and the values defined.

Generally it is not wise to ignore errors :-) This could yield unexpected results