Hi Team,

I am getting error 1004 in vba for following code:

If Range(errorTrnsID).Value = 10862 Then
Range(odlData1).Select
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-7],'ODL " & saveDate & ".txt'!C3:C65,25,FALSE)" (error is occurring in vlookup) odlValue1 = Range(odlData1).Value
Range(odlData3).Select
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-9],'ODL " & saveDate & ".txt'!C3:C65,24,FALSE)"
odlValue3 = Range(odlData3).Value
Range(odlData4).Select
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-10],'ODL " & saveDate & ".txt'!C3:C65,17,FALSE)"
odlValue4 = Range(odlData4).Value
Range(odlData5).Select
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-11],'ODL " & saveDate & ".txt'!C3:C65,26,FALSE)"
odlValue5 = Range(odlData5).Value
Range(errorInfo).Value = "<" & tdate & " " & userNm & "> Please confirm address of " & odlValue1 & " " & odlValue3 & " " & odlValue4 & " " & odlValue5 & ". Please confirm address to remove bad address indicator."
End If


please suggest how to resolve this issue.