Hello, have the following code, and when it cannot find #N/A in the pivotfield it returns 1004 error code, is there anyway I can adapt the code to ignore it if this is the case?
Many thanks.
Sub Pivot_Table()
Dim sht As Worksheet
Dim pvtCache As PivotCache
Dim pvt As PivotTable
Dim StartPvt...