Custom Pivot Table Design in VBA

[j_hsu]

Hi,

I'd like to know if it's possible to copy and paste a pivot table with a customized design into a new tab using VBA. I'm able to complete the action manually using Clipboard; however, the Clipboard appears to be empty when the process is recorded in Macro Recorder. I'm new to VBA and do not have any programming background so I'd greatly appreciate if anyone can provide the code if that's what it takes to have this done.

Thanks,

j_hsu

[j_hsu]

Hi, I'd like to be more specific about my question posted earlier:

I'm trying to copy and paste a pivot table with a customized design into a new tab leaving only the value and format using VBA. I tried copying and pasting as value and then format but failed, the custom design wasn't carried over as painted format (Font section in the Home ribbon) would. I'm able to complete the action manually using Clipboard; however, since I am doing this repetitively I need a Macro to automate the process but the Clipboard appears to be empty when the process is recorded in Macro Recorder.

Thanks,

j_hsu