Issue with Pivotcaches identification

[Gringoire]

Hello guys,
I use the code below to create a new PivotCache into PivotCaches object:

Mysheet.PivotCaches.Create(SourceType:=xlDatabase, SourceData:=SourceSheet.ListObjects("TabRawData"), Version:=xlPivotTableVersion15)

It happens that sometime I have more than one PivotCache and I would like to cancel just one of them, but each PivotCache is only referenced as Item1, Item2, etc...
the "Item1" name does not tell me nothing about its contents, so I would like to assign, at creation time, some kind of name to each new PivotCache in order to better handle it.

Unfortunately it seems that PivotCache has no Name property...

Do you know some workaround to obtain the same result?
The property SourceData is useless because it could vary dinamically.

Thanks in advance.

 

[RoryA]

How would you determine which cache needs replacing? Given that the name is fairly meaningless, what would identify the one to change?