Recorded pivot macro run time error 5

**cindywylie** · 04-17-2014, 01:54 PM

Hello,

I recorded a pivot macro that only worked one time. Now when I try to run the macro, I get a run time error. Can anyone help? Sample sheet attached. Thanks

**bigroo1958** · 04-17-2014, 02:14 PM

Hi Cindywylie,

I believe the reason you cannot run the macro a second time I suspect, is because sheet1 in your macro has already being used and assigned a pivot table1 as per your code.
You can close the spreadsheet down and open again and re-run, it worked for me!!

**cindywylie** · 04-17-2014, 02:29 PM

Each month I create a new tab. Will I be able to use this macro on all future tabs?

**cindywylie** · 04-18-2014, 08:58 AM

Is there a way to modify a recorded pivot to be used on new worksheets in a workbook

**bigroo1958** · 04-18-2014, 01:17 PM

Hi Cindywylie,

Sorry, I don't have the answer to your question, I am learning VBA myself, but my first response to your question was my first observation, I am hoping someone will come along with the correct answer to assist you!

**cindywylie** · 04-18-2014, 03:36 PM

Bigroo - Thanks for the try. I appreciate it just the same.

**bigroo1958** · 04-18-2014, 08:38 PM

Hi CindyWylie,

I did find this spreadsheet with "Create Pivot" in the 4 modules. I ran this over and over again and appears to work fine with the sample data..
Maybe you can modify the code for your needs??

Thanks