Hi guys!
So I'm new to creating macros with VBA and am trying to create one (just finished recording and started debugging) that basically encompasses creating a pivot table from a data set, sorting it in the pivot table, running some calculations on the data, and then graphing the results. The code runs up until the point where the pivot table is created, at which point I get this error
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"'Transposed'!R1C2:R2794C23", Version:=xlPivotTableVersion14).CreatePivotTable _
TableDestination:="'Sheet4'!R3C1", TableName:="PivotTable1", DefaultVersion _
:=xlPivotTableVersion14
Does anyone have any ideas? I tried adding apostrophes around the source data and destination fields, but that didnt seem to work either.
Any ideas?!
Thank you in advance!
So I'm new to creating macros with VBA and am trying to create one (just finished recording and started debugging) that basically encompasses creating a pivot table from a data set, sorting it in the pivot table, running some calculations on the data, and then graphing the results. The code runs up until the point where the pivot table is created, at which point I get this error
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"'Transposed'!R1C2:R2794C23", Version:=xlPivotTableVersion14).CreatePivotTable _
TableDestination:="'Sheet4'!R3C1", TableName:="PivotTable1", DefaultVersion _
:=xlPivotTableVersion14
Does anyone have any ideas? I tried adding apostrophes around the source data and destination fields, but that didnt seem to work either.
Any ideas?!
Thank you in advance!
