i have a script which worked but now fails.

The line is the following

ws.Cells(4, 4).Formula2 = "=SUM(SUMIFS(Cost[Wert/BWähr],Cost[Personalnummer],[@PN],Cost[Geschäftsjahr],D$2,Cost[Periode],D$1,Cost[Position],SEQUENCE(ROWS(UNIQUE(Cost[Position])),,100,100),Cost[Partner-Objektart],""<>VBP"";Cost[Referenzvorgang];""<>BKPF""))*TransferFaktor"

This results in error 1004, object error

If I change it to the german variant

ws.Cells(4, 4).FormulaLocal "=SUMME(SUMMEWENNS(Cost[Wert/BWähr];Cost[Personalnummer];[@PN];Cost[Geschäftsjahr];D$2;Cost[Periode];D$1;Cost[Position];SEQUENZ(ZEILEN(EINDEUTIG(Cost[Position]));;100;100);Cost[Partner-Objektart];""<>VBP"";Cost[Referenzvorgang];""<>BKPF""))*TransferFaktor"

I get the error 438, method not supported.

If I insert the formula directly in the cell it works…

I have no idea how to solve or debug this, any ideas?