title: Compile Error: Expected: Expression PivotTable
body: <p>I'm currently having this issue while running VBA code. I've created code that downloads a report from SAP GUI and with that spreadsheet I need to create a PivotTable. I used the Macro Recorder to create the pivot but I'm having this issue while running it.</p>
  
  <pre><code>Range("A1").Select
  Range(Selection, Selection.End(xlToRight)).Select
  Range(Selection, Selection.End(xlDown)).Select
  Sheets.Add
  ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
      "Sheet1!R1C1:R1500C18", Version:=xlPivotTableVersion14).CreatePivotTable
      TableDestination:="Sheet4!R3C1", TableName:="PivotTable1", DefaultVersion _
      :=xlPivotTableVersion14
  Sheets("Sheet4").Select
  Cells(3, 1).Select
  With ActiveSheet.PivotTables("PivotTable1").PivotFields("Company Code")
      .Orientation = xlRowField
      .Position = 1
  End With
  With ActiveSheet.PivotTables("PivotTable1").PivotFields("FI / MM Doc")
      .Orientation = xlRowField
      .Position = 2
  End With
  ActiveSheet.PivotTables("PivotTable1").AddDataField ActiveSheet.PivotTables( _
      "PivotTable1").PivotFields("Document number"), "Count of Document number", _
      xlCount
  </code></pre>
  
  <p>The issue appears in the <code>Tabledestination:="Sheet4!R3C1"</code>, row showing up the ":=" as an unexpected error.</p>
  
  <p>Do you guys know how can I solve this?</p>