Run-time 1004 error: Application-defined or object-defined error.

[charlesrobinsonhelp]

When I ran my maco I received a Run-time 1004 error: Application-defined or object-defined error. Do you know what is causing this error/ how to fix it?

 

[JLGWhiz]

The 1004 error is normally related to user input. Something misspelled, missing punctuation (comma, period, parentheses), etc. or too much punctuation.

 

[charlesrobinsonhelp]

Thank you for the feedback. I guess it's because of too much punctuation as I recorded the macro by manually entering the formula.

 

[JLGWhiz]

If you post the parts of the macro that errors, you can get much better analysis and advice. Just copy it into the thread window, highlight it and click one of the tag helper buttons below to set the code tags.

 

[charlesrobinsonhelp]

If Range("i14") = "EMEA" Then
Range("J14").Select
ActiveCell.FormulaR1C1 = "0"
Range("K14").Select
ActiveCell.FormulaR1C1 = _
"=SUMIF('Raw data'!C1,CONCATENATE(R8C,""-"",R1C[-3],""-"",R2C8,""-"",R[26]C4),INDEX('Raw data'!C1:C17,0,MATCH(R5C[1],'Raw data'!R2C1:R2C17,0)))+SUMIF('Raw data'!C1,CONCATENATE(R8C,""-"",R1C[-3],""-"",R2C8,""-"",R[31]C4),INDEX('Raw data'!C1:C17,0,MATCH(R[-9]C[3],'Raw data'!R2C1:R2C17,0)))+SUMIF('Raw data'!C1,CONCATENATE(R[-6]C,""-"",R[-13]C[-3],""-"",R[-12]C[-3],""-""" & _
"[-8]),INDEX('Raw data'!C1:C17,0,MATCH(R[-9]C[3],'Raw data'!R2C1:R2C17,0)))+SUMIF('Raw data'!C1,CONCATENATE(R[-6]C,""-"",R[-13]C[-3],""-"",R[-12]C[-3],""-"",R[-9]C[-8]),INDEX('Raw data'!C1:C17,0,MATCH(R[-9]C[3],'Raw data'!R2C1:R2C17,0)))"
Range("L14").Select
ActiveCell.FormulaR1C1 = _
"=SUMIF('Raw data'!C1,CONCATENATE(R8C,""-"",R1C[-4],""-"",R2C8,""-"",R[26]C4),INDEX('Raw data'!C1:C18,0,MATCH(R9C,'Raw data'!R2C1:R2C18,0)))"
Range("M14").Select
ActiveCell.FormulaR1C1 = "=SUM(RC[-3]:RC[-1])"