I have an array in VBA. I want to create a pivot table. How do I do that? normally I use the following code:
Set pvtCache = ActiveWorkbook.PivotCaches.Create( _
SourceType:=xlDatabase, _
SourceData:=SourceData)
But now hen my source data is a variant, I will probably need abnother sourcetype than xlDatabase?
Bookmarks