<div>
Can you provide an excel file example with a manual pivotable that is corresponding to your needs
</div>

shieldsco

<div>
<div class="content wysiwyg-content">
I'm using the code below and receive &nbsp;run-time error 1004 &nbsp;unable to get the pivot field property of the Pivot Table Class on line - Set rngGroup = PvtTbl.PivotFields(&quot;Dates&quot;).DataRange 
 
 

<pre><code class="code-10 nolinks" id="code-10-29177399-1">Sub PivotTableGroupData1()

Dim PvtTbl As PivotTable
Dim rngGroup As Range
Set PvtTbl = Worksheets(&quot;Data Chart&quot;).PivotTables(&quot;PivotTable1&quot;)

'set range of dates to be grouped
Set rngGroup = PvtTbl.PivotFields(&quot;Dates&quot;).DataRange

rngGroup.Cells(1).Group Periods:=Array(False, False, False, False, True, False, False)

'to ungroup:
'rngGroup.Cells(1).Ungroup

End Sub
</code></pre>
</div>
</div>

I'm using the code below and receive  run-time error 1004  unable to get the pivot field property of the Pivot Table Class on line - Set rngGroup = PvtTbl.PivotFields("Dates").DataRange


(CODE)

Excel VBA Error

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.