Hi all, I'm getting a runtime error using this formula with ExecuteExcel4Macro, it works fine if I use Range(??).formulaR1C1 = _ _ _,
does anyone have any suggestions please?

ExecuteExcel4Macro("SUMPRODUCT(--ISNUMBER(SEARCH(""O2sms1"",'[campaign_reponse_counts_FW20_LO_No_Pivots.xls]Overall'!R3C1:R180C1)),OFFSET('[campaign_reponse_counts_FW20_LO_No_Pivots.xls]Overall'!R3C1:R180C1,,MATCH(""Response FW15"",'[campaign_reponse_counts_FW20_LO_No_Pivots.xls]Overall'!R3C1:R3C127,0)-1))")

Many thanks in advance!