I am trying to insert a formula into a cell as part of a Macro and it keep giving my a 1004 error but I can't figure out why. Any help would be greatly received. code below
ActiveCell.FormulaR1C1 = _
"=((((SUMIFS(Data!C5,Data!C13,RC3,Data!C1,"">=""&R4C3,Data!C1,""<=""&R4C4,Data!C19,R5C))/R19C)*(SUMIFS(Data!C5,Data!C13,""Other Leave"",Data!C1,"">=""&R4C3,Data!C1,""<=""&R4C4,Data!C19,R5C)))+((((SUMIFS(Data!C5,Data!C13,RC3,Data!C1,"">=""&R4C3,Data!C1,""<=""&R4C4,Data!C19,R5C))/R19C)*(SUMIFS(Data!C5,Data!C13,""Holiday"",Data!C1,"">=""&R4C3,Data!C1,""<=""&R4C4,Data!C1" & _
"+((((SUMIFS(Data!C5,Data!C13,RC3,Data!C1,"">=""&R4C3,Data!C1,""<=""&R4C4,Data!C19,R5C))/R19C)*(SUMIFS(Data!C5,Data!C13,""Sick Leave"",Data!C1,"">=""&R4C3,Data!C1,""<=""&R4C4,Data!C19,R5C)))+(SUMIFS(Data!C5,Data!C13,RC3,Data!C1,"">=""&R4C3,Data!C1,""<=""&R4C4,Data!C19,R5C)))))"
Bookmarks