vba Lengthy formula split help

[Mallesh23]

Hi Team,


please assist for breaking the lengthy formula line by using line Continuation
When I tried getting error message, compile error expected list seperator or)


its working formula
Range("m2").FormulaR1C1 = _
"=SUMPRODUCT(ISNUMBER(MATCH(R2C8:R239C8," & cr1 & ",0))*ISNUMBER(MATCH(R2C9:R239C9," & cr2 & ",0))*ISNUMBER(MATCH(R2C11:R239C11," & cr3 & ",0))*ISERROR(MATCH(R2C10:R239C10," & cr4 & ",0)))"


expected result somewhat like this after breaking the formula
Range("m2").FormulaR1C1 = _
"=SUMPRODUCT(ISNUMBER(MATCH(R2C8:R239C8," & cr1 & ",0)) _
*ISNUMBER(MATCH(R2C9:R239C9," & cr2 & ",0)) _
*ISNUMBER(MATCH(R2C11:R239C11," & cr3 & ",0)) _
*ISERROR(MATCH(R2C10:R239C10," & cr4 & ",0)))"

Thanks
mg

 

[JoeMo]

Maybe:

Range("m2").FormulaR1C1 = "=SUMPRODUCT(ISNUMBER(MATCH(R2C8:R239C8," & cr1 & _
",0))*ISNUMBER(MATCH(R2C9:R239C9," & cr2 & ",0))*ISNUMBER(MATCH(R2C11:R239C11," _
& cr3 & ",0))*ISERROR(MATCH(R2C10:R239C10," & cr4 & ",0)))"

 

[Mallesh23]

Hi Joe,
Thank you it worked !!

Regards
mg

 

[JoeMo]

Hi Joe,
Thank you it worked !!

Regards
mg

You are welcome - thanks for the reply.