title: VBA code runs on 1 computer but gives syntax error on a different computer
body: <p>I recorded the macro below and it runs fine on my computer (excel 2016). However, when i run it in a different computer with excel 2013, it gives me "Syntax error" and highlight the formula to calculate column V "Status". It also seems to skip everything before, meaning not adding the 2 new columns and not calculating column U "Dates". Any idea on how to fix this? I'm not aware of the differences in syntax between the 2 excel versions. Thank you!</p>
  
  <pre><code> Sub ReportingStatus()
  
      Dim LastRow As Range
  
      'Add 2 columes and format them
      Range("U6").Select
          ActiveCell.FormulaR1C1 = "Dates"
          Range("V6").Select
          ActiveCell.FormulaR1C1 = "Status"
  
          Range("T6").Select
          Application.CutCopyMode = False
          Selection.Copy
          Range("U6:V6").Select
          Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
              SkipBlanks:=False, Transpose:=False
          Application.CutCopyMode = False
  
          Range("S65536").End(xlUp).Select
          ActiveCell.Offset(0, 2).Select
          Set LastRow = ActiveCell
  
      'Calculate the value for column U "Date"
          Application.ScreenUpdating = False
          Range("U7", LastRow).Select
  
          Selection.FormulaR1C1 = _
              "=IF(RC[-2]=""Awaiting Management Response"",R2C1-RC[-9],IF(RC[-3]&lt;&gt;"""",MAX(RC[-3]-RC[-4],R2C1-RC[-3]),R2C1-RC[-4]))"
  
          LastRow.Offset(0, 1).Select
  
      'Calculate the value for column V "Status"
          Range("V7", ActiveCell).Select
          Selection.FormulaR1C1 = _
              "=IF(RC[-3]=""Awaiting Management Response"",IF(RC[-1]&lt;1,""MGMT-CURRENT"",IF(AND(1&lt;=RC[-1],RC[-1]&lt;=60),""MGMT-DELAYED"",IF(AND(61&lt;=RC[-1],RC[-1]&lt;=90),""MGMT-SIGNIFICANTLY DELAYED"",""MGMT-CRITICAL""))),IF(RC[-1]&lt;1,""CURRENT"",IF(AND(1&lt;=RC[-1],RC[-1]&lt;=60),""DELAYED"",IF(AND(61&lt;=RC[-1],RC[-1]&lt;=90),""SIGNIFICANTLY DELAYED"",""CRITICAL""))))"
          Range("V7").Select
  
          Columns("U:V").EntireColumn.AutoFit
  </code></pre>