Error running macro

[KriCo]

I have a problem when i'm running this macro.
I get "Runtime error 1004" on the highlighted sentence.

Can anyone help me please ?

 

[JackDanIce]

Try replacing line in yellow and the line above with

With AcitveWorkbook.SlicerCaches
    cnt = .Count

 

[KriCo]

I started all over again.
So new file, same macro...

And strange enough, the error is gone and everything works just fine now.

Thx for your help !

 

[JackDanIce]

Not sure what I suggested works, but you're welcome! Glad error is gone anyway