Application defined or object defined error when creating a Pivot Table

I keep running into this error when I try to create a pivot table.

The debugger highlights the following line:

Please Login or Register  to view this content.

I noticed that when I delete the old pivot table that its supposed to replace, it will work, but otherwise it gives me the error.

The strange thing is that I don't seem to get this error the other places that I've done this. Replacing the old pivot table. I can't just make it update the table because sometimes, the table doesn't exist yet, which is why I create one.

Please let me know what the problem could be.

Thanks

Hi Kaiga
If you run the sub twice you will find the pivot tables have the same name

Kaigi
Incorporate some code like this code

Please Login or Register  to view this content.

hope it helps