Pivot Selection - Macro

[Bryan123]

Hi All,

In need of your help. I'm trying to create a macro that automatically create a pivot table from a sheet. I'm having trouble in capturing new saved entry. I think i need help with R1C1:R48C13 since 49th and the rest of the rows are not captured. Please help


ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"QA Error Correction Tracker!R1C1:R48C13", Version:=xlPivotTableVersion14). _
CreatePivotTable TableDestination:="Pivot!R3C1", TableName:="PivotTable1" _
, DefaultVersion:=xlPivotTableVersion14

Thank you
Bryan

 

[Bryan123]

Please help