Hello,

I would like to generate automatically the creation of a pivot table based on a pivotcache.

I have tried many different type of codes but I don’t manage to find a resolution to the error I get.

You will find below the code and attached the error message I get.

Any help will be appreciated.

The error when I run the macro is on this line of code:

Set monTCD = monCache.CreatePivotTable(ws1.Range(“EM2”), “monTCD”)

Thank you in advance.

Anthony

​Hello, I would like to generate automatically the creation of a pivot table based on a pivotcache.I have tried many different type of codes but I don’t manage to find a resolution to the error I get.You will find below the code and attached the error message I get.Any help will be appreciated. The error when I run the macro is on this line of code:Set monTCD = monCache.CreatePivotTable(ws1.Range(“EM2”), “monTCD”) Thank you in advance.Anthony    Read More

​