Variable range in PivotTable

R

Ron Luzius

How can I get a variable range in this VBA code instead of this hard-coded
range?

Every time I run my Excel macro, I will have a different amount of rows to
include in the PivotTable code.

ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _
"'Total Open Discrepancies'!R1C1:R1345C25").CreatePivotTable
TableDestination _
:="", TableName:="PivotTable1"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Variable Address in Pivot Table VBA code 4
Pivot Table Macro with dynamic source data 1
Unable to make a pivot table in excel sheet2 0
Pivot table in VB 3
Macro to create pivotchart problems 0
Upadte PivotTable Data range 2
Please Help! Need to add a Variable Range in my Excel Macro withPivot Tables 3
Loop through sheets and create a small PivotTable on each 2

Top