Hi All

Thank you all in advance

I’m trying to use the following code and it always retunes a #VALUE!

Cells(lngRow, "S") = Evaluate (“IF(OR(SUMPRODUCT(--($J" & lngRow & "='TC5RARULE ATT'!$P$2:$P$65000),--($M" & lngRow & "='TC5RARULE ATT'!$O$2:$O$65000))>0, SUMPRODUCT(--($J" & lngRow & "='TC5RARULE ATT'!$S$2:$S$65000),--($M" & lngRow & "='TC5RARULE ATT'!$R$2:$R$65000))>0),1,0)")

But it works fine when I don’t use the 'evaluation'

Cells(lngRow, "S") = “=IF(OR(SUMPRODUCT(--($J" & lngRow & "='TC5RARULE ATT'!$P$2:$P$65000),--($M" & lngRow & "='TC5RARULE ATT'!$O$2:$O$65000))>0, SUMPRODUCT(--($J" & lngRow & "='TC5RARULE ATT'!$S$2:$S$65000),--($M" & lngRow & "='TC5RARULE ATT'!$R$2:$R$65000))>0),1,0)"

Can you please help?