Hi. I currently have a program that creates a pivot table. I want to create
another pivot table that keys off of the same data, but would like to use the
"cached" data rather than re-use the same data. I have the second pivot
table command below. How would I rewrite this to reference the cached data?
Thanks, Mike.

ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatab ase, SourceData:= _
"RAWData!A1:AE" & lastRow).CreatePivotTable TableDestination:="",
TableName:= _
"PivotTable4", DefaultVersion:=xlPivotTableVersion10