Pivot table not created due to sheet reference

Hello,

I have the below code to create a pivot table based off of a data set. It is a template that will be used going forward however the code references Sheets("Sheet33").Select in it. The problem with this is when I test and delete tabs and rerun the code the sheet is not Sheet 33 any longer. What can I put to make it dynamic? I have code that creates two pivot tables and they both have this problem.

Please Login or Register  to view this content.

Hi there,

This proposed solution is untested as I don't have access to your workbook.

I'm assuming (maybe a BIG assumption!) that the "Sheet32" you're referring to is the name which Excel assigned to the new worksheet when you created your code using the macro recorder.

See if the following code does what you need - I've tried to tidy up the code generated by the macro recorder:

Please Login or Register  to view this content.

The newly-created worksheet will appear as the last worksheet of the workbook.

You can change the highlighted values to suit your own requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

Thanks Greg!

I ended up rebuilding the code with some google research and was able to get it to work. The code is below. I appreciate your help.

Please Login or Register  to view this content.

Hi again,

Many thanks for your very prompt feedback and also for the Reputation increase - much appreciated!

You're welcome - glad I was able to help.

Best regards,

Greg M