Match function is malfunctining if variable is used as arg1

I'll give it a try but I'll tell you what might be the problem - the array is being populated from a combobox/listbox so it's populated with strings, not numbers.

That would be a problem if the column you were trying to find a match in had numeric data.

Hard to tell if that's the case because, well, there's no data on any of the sheets apart from a header row on 'Input'.

Another problem is that a match just isn't being found, perhaps because there's no data.

If that's what's happening here's how you can deal with it.

Dim MatB As Variant ' allows MatB to be an error value

' other code

    Set MatB = Application.Match(choice(y), Columns("B:B"), 0) ' Application.Match should prevent a runtime error

    If IsError(MatB) Then
        MsgBox choice(y) & " not found."
    End If