Pivot Table Rows not getting listed with Excel VBA

[bsguna]

I have the following requirement where I need to create the pivot table.

1) The issue is when I execute the macro its successfully completed, but the Rows are not refreshed in the table. But if I execute step by step in edit mode, I'm getting the required output.

2) 1st time when I run the macro its giving " Run time error 1004", but second time its running fine

The input and the code are attachment with it

Please Login or Register  to view this content.

[Richard Buttrey]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Please read the forum rules. This is the second infringement today.

Thread Closed.