FORMULAR1C1 problem

[zoepal]

Hey guys,

Im having a problem with the IF formula below, all time I run into an error and i dont know what else to do...its only this formula that needs to fill the requirements:
if the cell contains USD and the account number 150000 it should appear an OK message, otherwise CHECK message.

Much appreciated,


Set MyRegion = CList.Cells(1).CurrentRegion.Offset(1).Resize(CList.Cells(1).CurrentRegion.Rows.Count - 1)

With MyRegion
.Columns(8).FormulaR1C1 = "=IF(AND(RC[-3])=""USD"",RC[-2]=150000,""OK"",""CHECK""))"
End With

[maras_mak]

Maybe try.

Please Login or Register  to view this content.