CreatePivotTable() error - Application-defined or Object-defined error
<p><strong>OBJECTIVE</strong></p>

<p>Create pivot table based on a dynamic range of information.</p>

<p><strong>APPROACH</strong></p>

<ol>
<li>Identify and Activate sheet (<code>ws</code>) that contains source data (<code>srcData</code>, <code>lastRow</code>) for pivot table</li>
<li>Identify <code>target</code> sheet where new pivot table (<code>pvt</code>) will be displayed</li>
<li>Highlight and record source data (<code>srcData</code>)</li>
<li>Create pivot cache (<code>pvtCache</code>)</li>
<li>Place pivot table (<code>startPvt</code>) on worksheet &amp; cell</li>
</ol>

<p><strong>CODE</strong></p>

<pre><code>Sub createPivot()

Dim ws As Worksheet
Dim pvtCache As pivotCache
Dim pvt As pivotTable
Dim srcData As String
Dim lastRow As Long
Dim startPvt As String
Dim target As Worksheet

'Select pivot table data
Worksheets("CONSOLIDATED").Activate
Set ws = ActiveSheet
lastRow = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row
srcData = ActiveSheet.Name &amp; "!" &amp; Range("A1:H" &amp; lastRow).Address(ReferenceStyle:=xlR1C1)

'Set pivot table location
Set target = ThisWorkbook.Worksheets("PIVOT")
startPvt = target.Name &amp; "!" &amp; target.Range("A1").Address(ReferenceStyle:=xlR1C1)

'Create pivot cache
Set pvtCache = ActiveWorkbook.PivotCaches.Create( _
    SourceType:=xlDatabase, _
    SourceData:=srcData)

Set pvt = pvtCache.CreatePivotTable( _
    TableDestination:=startPvt, _
    TableName:="PivotTable1")

End Sub
</code></pre>

<p><em>inspired by: <a href="http://www.thespreadsheetguru.com/blog/2014/9/27/vba-guide-excel-pivot-tables" rel="nofollow">http://www.thespreadsheetguru.com/blog/2014/9/27/vba-guide-excel-pivot-tables</a></em></p>

<p><strong>ISSUES</strong></p>

<blockquote>
  <p>Run-time error '1004': Application-defined or object-defined error</p>
</blockquote>

<p>@ line:</p>

<pre><code>Set pvt = pvtCache.CreatePivotTable( _
    TableDestination:=startPvt, _
    TableName:="PivotTable1")
</code></pre>

<p><strong>QUESTIONS</strong></p>

<ol>
<li>Am I going crazy? I've proofread this code multiple times and cannot understand where I am going wrong. At this point, I am at a loss. Any help is appreciated with an explanation on why the error has occurred. </li>
</ol>