VBA Runtime Error 1004 Cannot read property

Hello,

I created a macro using the recorder and it was working fine until I changed my extractions (which are exactly the same). I received a runtime error message 1004 - Unable to read the PivotTables property of the Worksheet class. But when I tried again a little later, it worked again...???

Do you know where the problem might come from? I'm afraid it might happen again.

Thank you very much in advance for your help,

Best regards

1 answer

  1. Hello,

    Without seeing the file, it would be difficult to assist you.

    Sincerely