“Evaluate” a formula with = IF (OR (SUMPRODUCT(…. in VBA

Hi All

Thank you all in advance

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

Please Login or Register  to view this content.

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)")

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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)"

Please Login or Register  to view this content.

Can you please help?