Solved: Iserror in VBA setup

[klutz]

Hello,

How can i set this formula in VBA with the "iserror"?

[VBA].Offset(3, -2).FormulaR1C1 = "=LOOKUP(2,1/((R27C7:R" & lngLastRow & "C7=R[-2]C[2])*(R27C28:R" & _
lngLastRow & "C28=R[1]C)),R27C11:R" & lngLastRow & "C11)"[/VBA]

Thanks...

[Zack Barresse]

Use the Evaluate() method to get the formulas return. You can then check the returned result.

HTH

[Bob Phillips]

[vba]

ActiveCell.Offset(3, -2).FormulaR1C1 = _
"=IF(ISERROR(LOOKUP(2,1/((R27C7:R" & lngLastRow & "C7=R[-2]C[2])*(R27C28:R" & _
lngLastRow & "C28=R[1]C)),R27C11:R" & lngLastRow & "C11)),""""," & _
"LOOKUP(2,1/((R27C7:R" & lngLastRow & "C7=R[-2]C[2])*(R27C28:R" & _
lngLastRow & "C28=R[1]C)),R27C11:R" & lngLastRow & "C11))"
[/vba]

[klutz]

Not even sure how to set it up using your suggestion Zack. :-(. Aint't that keen yet using VBA....


Thankx XLD...i almost had it, something like yours except for some quotation missing...

Gracias...

[Zack Barresse]

Ah, I thought you meant you wanted to check if it was an error in VBA. Glad you have it working though.