VBA code error

[arnab0711]

Hi,
I am trying to create this dynamic pivot table but I am getting multiple error,pls help me in debugging it.I am attaching the pivot picture for your persual.

Please Login or Register  to view this content.

[romperstomper]

Please put code tags around your code or we can't assist you.
Ta.

[arnab0711]

Tagged as per forum rules

[romperstomper]

Hmm, my last post seems to have gone missing.
Can you post a sample workbook, or at the very least tell us which lines are causing the errors (and what the errors are)? A picture of a pivot table doesn't really help much.

[arnab0711]

Hi,
I am getting Run time Error 1004
I have also attached the workbook along with the picture

[romperstomper]

Your worksheet is not called Data, there is no 'logic' field in the table and you need to include the header row in your named range. Then this works:

Please Login or Register  to view this content.

[arnab0711]

Hi,
I tried to do it,but still cannot debug the errors,
can you provide the correct code that works

[romperstomper]

That is the correct code that works. Did you make the 3 changes I noted to your workbook?

[arnab0711]

Hi,
I am not getting what do you mean my header row,do you mean to add another row.

[romperstomper]

Your named range starts from A2 - it needs to start from A1.