Pivot Table Macro with dynamic source data

C

Corrie

We've upgraded to Excel 2010. In past macros, I've been able to make
a pivot table dynamic with this script (below) and swapping out the
set range for Range(A1).

ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase,
SourceData:= _
Range("A1").CurrentRegion.Address).CreatePivotTable
TableDestination:="", TableName:= _
"PivotTable3", DefaultVersion:=xlPivotTableVersion10


Now the script is different with

ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase,
SourceData:= _
"DL!R1C1:R163C16",
Version:=xlPivotTableVersion10).CreatePivotTable _
TableDestination:="Sheet4!R3C1", TableName:="PivotTable2",
DefaultVersion _
:=xlPivotTableVersion10

If I add Range ("A1"), in place of "DL!R1C1:R163C16" I get an error
message. Any ideas?
 
T

Tim Williams

Can you post the exact code you're getting the error with, and the
number+text of the error?

Tim
 

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

Pivot table code question 2
Playing back a Pivot Table macros 2
Avoiding an extra sheet when creating a pivot table 3
Creating a Pivot Table via Macro - Errors on Recorded Code 3
Build Pivot Table with VBA; Keeps Throwing an Error 1
Why R1C1 range parameters in VBA Pivot Table setup/ 13
pivot cache in VBA 0
Programming a macro in Excel Office 2007 to create Pivot Table 1

Top