Hi
I am trying to add this formula trough VBA to a cell but gets an #NAME? Error, but when i click in the formula bar and press enter i works perfectly.
I want it to work directly the VBA put it in the cell ?
![]()
Worksheets("Blad1").Cells(7 + ((x - 1) * 19), 3).FormulaR1C1 = "=SUMIFS(Budget_Kredit!R[-6]C:R[993]C,Budget_Kredit!R[-6]C[-1]:R[993]C[-1],Settings!R[-6]C[-2])"
Best regards
Petter
Bookmarks