Adding Pivot through the VBA

[Skorpionkz]

Hello, I recorded Macro to add Pivot Table.

For some reason recorded code does not work

Please Login or Register  to view this content.

Can some one help me to modify this part of code?

[arlu1201]

What error do you get? On which row?

[Skorpionkz]

Please Login or Register  to view this content.

this is one row

I got run time error 5

[arlu1201]

Try changing the destination sheet name from Pivot Table to Pivot_Table.

Also if you are using excel 2007, then change this from xlPivotTableVersion14 to xlPivotTableVersion12.

[Skorpionkz]

Thanks name change helped.