Application.Match returns Error 2042 whene text absolutely does exist?

I don't need to driven crazy, it's close enough to walk...

I'm posting this for the next guy that might need it.

I've been working for months on a very large macro/vba task to simplify router data research.

x() is an array that is loaded from a text file, using:
x = Split(CreateObject("Scripting.FileSystemObject").OpenTextFile(rName(rCount)).ReadAll, vbCrLf) ' x-Array will contain router dump

I can expand that array in the debug window and find the text I'm trying to find. So, I know it's there.

In part of my code, I have this line:
z = Application.Match("router bgp ", x, 0)

It returns Error 2042 and I figured it out.

z = Application.Match("router bgp *", x, 0)

Turns out "Application.Match" matches the entire line and is happy with wild cards.

Yes, I solved this, by realising that "Application.Match" defaults to an exact match, and wildcards must be used if a partial match is ok.
Also, a little care should be taken so if the match does fail, you don't get stuck with an error. I can't "Dim z As Integer", the code will die if I do get an error.

In my example, I do this:

z = Application.Match("router bgp *", x, 0)
If IsError(z) Then
    msgbox "deal with text not in array"
Else
    z = z - 1
    msgbox x(z)
End If

The only trouble I have now is dealing with duplicate data. I need an elegant way to do that, but will figure it out in a different thread.