![]() XlPivotTableVersion12).CreatePivotTable(DestRng, "aaa", True, xlPivotTableVersion12) Set PivotTbl = (xlDatabase, ETws.Cells(1, 1).CurrentRegion, _ Set DestRng = ActiveWorkbook.Sheets("ETPivotTbl").Cells(1, 1) ' This will be done by creating a new ws as a pivot tableĪctiveWorkbook.Sheets("ETPivotTbl").Columns("A:T").Delete Shift:=xlToLeft ' If there are multiple ET codes for the same project, FACTDesc, and month ![]() ![]() I've added more rows to the data that the pivot table sources from, but since I can create the pivot manually I think that's not the issue. Anyone know in detail what the type mismatch error indicates. I've run this code frequently for the last few months and have made no changes to the code. I'm getting a "Run Time '13': Type mismatch" error on the last line of code (Set PivoTable code.). I'm getting a macro error when i run the following macro.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |