Macro to Copy Pivot Table Value and Custom Design

[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 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. 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 <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->

 

[lody0080]

not sure if Macro recognizes clipboard. at least when i try to record it it doesn't do anything. I am sure the xperts here can answer your question.