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?

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)

Hi @sssim4567
image

or

image

regads,
LNV

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

You can record macro :slight_smile: