A VBA code within a XLSM file doesn´t work anymore after replacing a cell range

Hi there,


I’m facing to a weird issue in big VBA program for which I spent several weeks.

The code essentially reads a big list of data within a cell range, and computes several filters, as well as build a pivot table to extract the required result.
Both the list and the code lies inside the Sheet1 spreadsheet and worked fine so far, but once I replace the list ( by manually deleting the current cell range, and place another list pasted form external a sheet ) the code stops working, raising an error at the stage where should manage a pivot table (PV) object, just created. I suspect that this is happening due to the fact that this PV were created at this same Sheet1, and probably the manual delete-copy-paste of the previous list would perhaps delete some hidden attribute of the project, is it right ?


Thank in advance,

The whole code unfortunately has several references to the table contents, therefore there are restrictions to its disclosure.
Anyway, the error occurs exactly at the line highlighted bellow:

Please Login or Register  to view this content.

The above code is at a module called by the following method, created just to catch errors:

Please Login or Register  to view this content.

It is instantiated by the following command:

Please Login or Register  to view this content.

Concerning to the worksheet superimposed “attribute” above mentioned as a possible reason of the problem, it was not an affirmation, but just a guessing. I actually even are not sure about that.
I really don’t understand how a manual update of the table content could yield the error:

Fail.jpg

Note:
Although the above system message isn't in english, I´m assuming it is intuitive uderstand it meaning...