I thought this code would work to create a temporary pivot table so I can get some values, paste them, then get rid of the table, but it's hard to do that if the table won't create itself. SourceData:=pRange.Address).CreatePivotTable( _ Set pRange = sARR.Cells(1, 1).Resize(lastRow, lastCol) LastCol = sARR.Cells(1, Columns.Count).End(xlToLeft).Column
LastRow = sARR.Cells(Rows.Count, 1).End(xlUp).Row I've tried running with variables as strings, ranges, variants, and I still run into an error 1004: application-defined or object-defined issue. I've tried running multiple variations of the code below, but to no avail.
I've got my variables set up, but unfortunately, I keep running into errors when I try to run the code below. I'm currently trying to create a temporary table with Excel VBA in Excel 2016.
0 kommentar(er)
