Jolenelity
New Member
- Joined
- Jun 3, 2013
- Messages
- 6
Hi, just one more question... For this codes: The one which is highlighted in red, how can I make it to dynamic range too?
Sheets.Add
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"Residential Raw!R1C1:R659C34", Version:=xlPivotTableVersion14). _
CreatePivotTable TableDestination:="Sheet1!R3C1", TableName:="PivotTable6" _
, DefaultVersion:=xlPivotTableVersion14
Thank you!
Sheets.Add
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"Residential Raw!R1C1:R659C34", Version:=xlPivotTableVersion14). _
CreatePivotTable TableDestination:="Sheet1!R3C1", TableName:="PivotTable6" _
, DefaultVersion:=xlPivotTableVersion14
Thank you!