Hi there,

Was given what I thought was the simple task of pasting a formula via a macro into a range of cells; unable to make it happen however. Works properly when pasted in cells as regular function. I've used the macro recorder to get the formula into vba, still no dice, error 1004, whether inserting into range or a single cell. I realize it is a long formula but I'm using Excel 2013, didn't think length would be an issue. Formula is sound, should work in a macro right? Anyways, here it is:

 Sub test3()

    Range("F30:M37").FormulaR1C1 = _
        "=IFERROR(IF(R19C3=TRUE,IF(R8C13=""ALL"",COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R20C50),""<=""&R10C67)/RC4,(COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),R8C13,INDIRECT(R20C50),""<=""&R10C67)+COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),R10C13,INDIRECT(R20C50),""<=""&R10C67)+COUNTIFS(INDIRECT(R16C50" & _
        "DIRECT(R18C50),R29C,INDIRECT(R14C50),R12C13,INDIRECT(R20C50),""<=""&R10C67)+COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),R14C13,INDIRECT(R20C50),""<=""&R10C67)+COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),R16C13,INDIRECT(R20C50),""<=""&R10C67))/RC4),IF(R17C3=TRUE,IF(R8C13=""ALL"",COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(" & _
        "29C,INDIRECT(R14C50),""<>[LOGIS]*"",INDIRECT(R14C50),""<>[SERVC]*"",INDIRECT(R20C50),""<=""&R10C67)/RC4,(COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),""<>[LOGIS]*"",INDIRECT(R14C50),""<>[SERVC]*"",INDIRECT(R14C50),R8C13,INDIRECT(R20C50),""<=""&R10C67)+COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),""<>[LOGIS]*"",INDIRECT" & _
        """<>[SERVC]*"",INDIRECT(R14C50),R10C13,INDIRECT(R20C50),""<=""&R10C67)+COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),""<>[LOGIS]*"",INDIRECT(R14C50),""<>[SERVC]*"",INDIRECT(R14C50),R12C13,INDIRECT(R20C50),""<=""&R10C67)+COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),""<>[LOGIS]*"",INDIRECT(R14C50),""<>[SERVC]*"",INDIRECT(" & _
        "14C13,INDIRECT(R20C50),""<=""&R10C67)+COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),""<>[LOGIS]*"",INDIRECT(R14C50),""<>[SERVC]*"",INDIRECT(R14C50),R16C13))/RC4),IF(R15C3=TRUE,(COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R20C50),""<=""&R10C67)-COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),Assumptions!R52" & _
        "CT(R20C50),""<=""&R10C67)-COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),Assumptions!R53C2,INDIRECT(R20C50),""<=""&R10C67)-COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),Assumptions!R54C2,INDIRECT(R20C50),""<=""&R10C67)-COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),Assumptions!R55C2,INDIRECT(R20C50)," & _
        "0C67)-COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),Assumptions!R56C2,INDIRECT(R20C50),""<=""&R10C67)-COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),Assumptions!R57C2,INDIRECT(R20C50),""<=""&R10C67)-COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),Assumptions!R58C2,INDIRECT(R20C50),""<=""&R10C67)-COUNT" & _
        "ECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),Assumptions!R59C2,INDIRECT(R20C50),""<=""&R10C67)-COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),Assumptions!R60C2,INDIRECT(R20C50),""<=""&R10C67)-COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),Assumptions!R61C2,INDIRECT(R20C50),""<=""&R10C67)-COUNTIFS(INDIRECT(R16C50)" & _
        "RECT(R18C50),R29C,INDIRECT(R14C50),Assumptions!R62C2,INDIRECT(R20C50),""<=""&R10C67)-COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),Assumptions!R63C2,INDIRECT(R20C50),""<=""&R10C67)-COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),Assumptions!R64C2,INDIRECT(R20C50),""<=""&R10C67)-COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50" & _
        "DIRECT(R14C50),Assumptions!R65C2,INDIRECT(R20C50),""<=""&R10C67)-COUNTIFS(INDIRECT(R16C50),RC3,INDIRECT(R18C50),R29C,INDIRECT(R14C50),Assumptions!R66C2,INDIRECT(R20C50),""<=""&R10C67))/RC4))),0)"
  
End Sub
Any help much appreciated.

Chas