在为功能区宏定义PivotCache
和创建数据透视表时,出现错误Run-time error '13': Type mismatch
。有人能解释一下为什么和如何修复它吗?
Dim PCache As PivotCache
'Define Pivot Cache and Insert Pivot Table
Set PCache = ActiveWorkbook.PivotCaches.Create _
(SourceType:=xlDatabase, SourceData:="Assigned!$A:$P"). _
CreatePivotTable(Worksheets("Assigned").Range("R3"), TableName:="Assigned` Cases")
https://stackoverflow.com/questions/50650662
复制相似问题