I've been testing a piece of code but can only get it to work when I set my variables to string values and look up an alpha character. When I change my variable to integer and look for a number, I get a "Type Mismatch Error 13". It seems to have something to do with the "evaluate" formula, but not sure. Your suggestions are welcome.
Below are two versions of my code. FindABC() works, while Find123() gets an error. A test worksheet with these routines are also attached.
Please Login or Register to view this content.