When I make an Excel pivot using INVOKE VBA, I want to change pivot style to Displays one column per tabular, what should I do?

sssim4567 · August 21, 2023, 9:20am

using INVOKE VBA, I made a pivot table and completed applying the necessary fields.

In addition to this
I want to display the pivot layout in table styles to Displays one column per tabular what should I do?

I will attach the MACRO file and the Excel file.

Please help me
TEST.xlsx (46.2 KB)
pivotMacro.txt (1.0 KB)

Nguyen_Van_Luong1 · August 21, 2023, 9:30am

or

regads,
LNV

sssim4567 · August 21, 2023, 9:38am

I want to change pivot layout style to Displays one column per tabular
Is there vba macro?

Nguyen_Van_Luong1 · August 22, 2023, 12:24am

You can record macro