Hello everyone! I have recorded a macro in excel. It's a very long code but the the following piece of code error appears. I have recorded the macro twice but the issue is same. The error screenshot is in attachment. Please help me resolve this issue. Thanks and Regards
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"Finder!R1C6:R65536C13", Version:=xlPivotTableVersion10). _
CreatePivotTable TableDestination:="Pivote Tables!R1C1", TableName:= _
"PivotTable6", DefaultVersion:=xlPivotTableVersion10
Bookmarks