Object Required in my Function to match an array

[TheRedCardinal]

I have a function (taken from here) to determine if a value appears in an array.

The value I'm looking for is the last entry in an array, in box 6.

I have coded as follows:

If ExportArray(UBound(ExportArray), 6) <> "" Then

    If IsInArray(ExportArray(UBound(ExportArray), 6).Value, CustomerData) = False Then
        MsgBox ("Customer Not Found")
    Else
        MsgBox ("Customer Found")
    End If

End If

The first line is because the table is blank and so I wanted to skip if this is the case.

My function looks like this:

Function IsInArray(stringToBeFound As String, arr As Variant) As Boolean
  IsInArray = Not IsError(Application.Match(stringToBeFound, arr, 0))
End Function

I get an Object required error at the "If IsInArray" line.

Which obvious error have I made?
Thanks,!

 

[TheRedCardinal]

I "fixed" the issue by ascribing the value from the array as its own variable:

    SearchStr = ExportArray(UBound(ExportArray), 6)

    If IsInArray(SearchStr, CustomerData) = False Then

I'd love to understand how to make this unneeded though?

 

[RoryA]

You need to remove the .Value from your first code. Arrays don't have properties like Value.