Pivot Table & Chart with Excel VBA - issue on mAcro

Hi,

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

The issue is when I press execute button the macro completed successfully, but the Rows in the table do not have any values. But if I execute step by step in edit mode, I'm getting the required output. I don't know what i'm missing why I face this issue

The input and the code in the attachment with it

Please Login or Register  to view this content.

Thanks
Guna

Unfirtunately your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

However why are you bothering to delete and then recreate your pivot tables each time you get new data. Just create a dynamic range name for your data and use that in the PTs definitions.

Originally Posted by bsguna

I made the changes to the code. Please let me know if i need to make any further changes

Thank you - that's fine.

Now just create dynamic range names and avoid the macro altogether, save perhaps for a single line of code in any macro that loads new data, or failing that the Sheet Activate event of the sheets that contain PTs. The single line of code would be

Please Login or Register  to view this content.

Hi Guna,

You are missing an important line at the end.

Please Login or Register  to view this content.