I am new in learning excel VBA but I am facing a issue in a line of a code where I am using vlookup lookup value in is ” collection data” and lookup array in “Pivot” sheet. But where excel executes that line a pop up appears call update value from where “Pivot” is missing which includes my lookup array.

I have an Excel macro that contains a pivot table. The macro has to read a worksheet and eliminate any line with a code that is not in the following list (1,5, 12, 7, 20). This part works good.

I’m wondering if there’s a way to format the 4th, 5th, etc… Row Subheading when modifying the pivot table styling in Excel or through VBA? I can see the Pivot Table Elements only allow styling up the the 3rd Row Subheading.

I’m trying to filter a pivot table with vba. “Unable to get the PivotFields property of the PivotTable class”