PivotTable range [VBA]

[Martin_H]

Hi,

I'm trying to figure out, how to refer to Pivot Table Range without having to directly type "$A$1:$BA$776" because the range varies. I would like to make it indirectly.

Here is part of the code.

Dim ws As Worksheet
Dim pc As PivotCache, pt As PivotTable
Dim ds As Range

Set ds = ActiveWorkbook.Worksheets("JUNE_DATA").Range("$A$1:$BA$776")
Set pc = ActiveWorkbook.PivotCaches.Create(xlDatabase, ds)

Help is much appreciated.


Thank you.

 

[Alex Blakenburg]

Yes. Have a look at this webpage.
Referencing Pivot Table Ranges in VBA - Peltier Tech

 

[Martin_H]

Yes. Have a look at this webpage.
Referencing Pivot Table Ranges in VBA - Peltier Tech

Once again thank you.

Solved everything I needed.