Runtime Error 5

[MarBoTJ]

Hello, I have an issue with this.

I have a macro that worked perfectly fine until I added code for it to add 2 more columns (with formulas) in a worksheet.
That works well, but when I create the Pivot Table it pops the error message.

This is the code for the pivot:

Please Login or Register  to view this content.

I don't know how to solve this, any help will be appreciated.

Thanks to all in advance.

[davesexcel]

Hi,
Can you indicate what line errors?