Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Match function, N/A error, how do I get around it?
In XL 2003 VBA, I am using the [application.worksheetfunction] Match
function to identify the position of a variable within another array. I am requiring an exact match. I just had my first instance where the match was not found anywhere, and per the help file: a.. If MATCH is unsuccessful in finding a match, it returns the #N/A error value. So in my code I tried to get around this with an If statement: If IsError (my match statement) then 'do nothing Else 'here is all my old code End if but it isn't catching the #N/A as an error, and I don't see any similar operators (?) that would catch the #N/A. Is there something else I can use? I don't want to use a generic "on error resume next" for the whole procedure, because I want to catch any other errors that might occur. I also have to make sure the rest of my code _doesn't_ run if the match isn't found, otherwise it will cause all sorts of other errors. I welcome and appreciate any advice or solutions you might have, Keith -- The enclosed questions or comments are entirely mine and don't represent the thoughts, views, or policy of my employer. Any errors or omissions are my own. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can we get unique values in match function for same match key. | Excel Worksheet Functions | |||
Worksheet function match - run time error | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
Match Function - no room for error | Excel Worksheet Functions | |||
Error Return Value from and INDEX(A:2,MATCH()) function | Excel Worksheet Functions |