error in highlighted section...RT error 91 object variable or with block not set...the same formula works between two sheets of the same workbook...but not two separate workbooks?!?!?!
[VBA]For i = 3 To lRow
Set findStr = Workbooks(wb).Sheets(1).Range("C" & i)
Workbooks(wbA).Sheets(1).Activate
Range("B1:B2000").Find _
(What:=findStr, _
LookIn:=xlValues, _
LookAT:=xlPart, _
SearchOrder:=xlByRows).Activate
foundCell = ActiveCell.Offset(0, -1).Value
Workbooks(wb).Worksheets(1).Cells(i, 9).Value = foundCell
Next i[/VBA]