October 2, 2022 at 7:10 PM #1 Hi guys,I am trying to run this code but keep getting syntax error.. Code Sub UpdateFormula() Range("K2").Formula = "=IF(ISNUMBER(MATCH(I2,'C1'!$I$2:I$66,0)),"","Not Found")" End Sub any ideas?Thank you
October 2, 2022 at 10:24 PM Best Answer #2 Use this instead (note the extra double-quotes that wrap the double-quotes presente inside the original formula code): Code Range("K2").Formula = "=IF(ISNUMBER(MATCH(I2,'C1'!$I$2:I$66,0)),"""",""Not Found"")"