Hi,
I want to copy data row from pivot table to another sheet. Sometimes the pivot table has a data and sometimes blank (Dynamic).
The problem is when the pivot table has no data the macro cannot run, its said: "Run error '1004' the formula is not complete. Make sure an ending square bracket ] is not missing"
I'm using this macro:
Please help, Thanks In Advance.PHP Code:
Sheets("PIVOT Agent Financing").Select
ActiveSheet.PivotTables("PivotTable2").PivotSelect "'Kode Agent'[All]", _
xlLabelOnly, True
Selection.Copy
Sheets("2.SYC FINANCING").Select
Range("A2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Bookmarks