I have an array of a bunch of different ID numbers. I'm trying to write a macro that will find the position of an ID number when entered. At first I tried using application.match. That worked if the ID number was only a number such as 12345, but if there were any letters, (A1234) it would not find it. So then I ditched application.match and just did a rudimentary loop to see if the value was equal to array(i). Again it works for pure numbers, but if any letters are present, it won't find it. The array I have is dimensioned as a string variable. I have no clue. Any ideas why this is happening?

---------- Post added at 10:43 AM ---------- Previous post was at 10:10 AM ----------

I swear I checked this before I posted, but I've discovered that there is a hidden space throwing it off...