M
Mcasteel
Im am receiving the above error with the following code.
Dim iRow As String
Dim CustSSN As String
'Fill variable with User Inputed Cust. SSN
CustSSN = txtCustSSN
iRow = WorksheetFunction.Match(CustSSN
Worksheets("sheet1").Range("f:f300"), 0)
If iRow = 0 Then
MsgBox "Customer SSN Was Not Found"
Else
MsgBox "Record Found"
End If
End Sub
The error is highlighting the first line of the above code
Dim iRow As String
Dim CustSSN As String
'Fill variable with User Inputed Cust. SSN
CustSSN = txtCustSSN
iRow = WorksheetFunction.Match(CustSSN
Worksheets("sheet1").Range("f:f300"), 0)
If iRow = 0 Then
MsgBox "Customer SSN Was Not Found"
Else
MsgBox "Record Found"
End If
End Sub
The error is highlighting the first line of the above code