Hi. I have a sheet with ~10 pivot tables, and I need a macro that runs through them, and leaves the sheet looking as it is, but with normal tables without formulas, instead of pivots.
The problem I keep running in here is that i don`t seem to be able to copy over the color formatting of the pivottables.
If I do it with ctrl+c/ctrl+v by selecting ranges it works, but it doesn`t when I use macro. (I just get values or nothing at all).

The code I`ve used so far.
Please Login or Register  to view this content.
The offset there is so that i wouldnt try to paste over the actual pivottables ( I intend to delete them with after the copy process).
Any ideas guys?