View original (French)

VBA Runtime Error 1004 Cannot read property

Jerome -  
Willzac Posted messages 281 Status Member -

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.
    Willzac Posted messages 281 Status Member 15
     

    Hello,

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

    Sincerely

    0