FindFirst with multiple criteria Text and Number [closed]

31 viewsexcelms accessvba
0

I’m probably missing something simple in my findfirst with multiple criteria.
The first part is is text the second part is currency/number. When run in my VBA I’m getting a type mismatch error.

 rs.FindFirst ("[Offer]= '" & ws.Range("I" & i).Value & "'" And "[RetOne] = " & ws.Range("B" & i).Value & "")

Any help would be greatly appreciated!