VBA, Paste Pivot Table Format?

[kestefon]

Hi All,

I'm using VBA to copy and paste a pivot table's values and formatting. For some reason, some of the cell coloring doesn't show up in the pasted result.

Please Login or Register  to view this content.

Any idea what I'm doing wrong?

[kestefon]

Anybody? I'm guessing it has to do with xlPasteFormats...maybe there's another option I should choose instead?

[kestefon]

And to clarify...I have a grey pivot table (one of the pivot table templates), but when I try to paste the results using the VBA code above, the coloring is lost.