Error 1004 - application defined or objecft defined error in 2010

[excelbugs_help]

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.

[Norie]

What's in savedata?

Also, what range do you want to look in?

PS Is there a reason you are using R1C1 notation?

[excelbugs_help]

We are saving comment depending on trans id.
This was working fine in 2003 but giving error in 2010

[Norie]

So what's in saveDate?

By the way, you should use code tags when posting code - you've not done that in any of your recent posts.