comparing cells in one column to another

C

cparsons

I have a column on a spreadsheet and an array of strings. I need to
look at the first cell on the spreadsheet and find a matching value in
the array of strings. This is how I am doing that
With ThisWorkbook.Worksheets(Tracker).Range("Order_Number_Header")
For E = 0 To Total_Rows_On_Spreadsheet - 1
For F = 0 To Total_Elements_In_Array - 1
If .Offset(E, 0) = FTS_Order_Number(F) Then
msgbox"I Have a Match
end if
next F
next E
end with

Nothing is matching and I know there are some matches. When I display
the value in the fields I see "12345678" for both fields.

The field on the spreadsheet is in a Text format.

Any suggestions? Maybe I need to changed the format of the fields.

Thanks,
Craig
 
Top