Copy Sheet with PivotTable to new Workbook

[lneidorf]

Hi there.

I want to copy a sheet with a PivotTable on it to a new workbook, preserving the values and formatting of the sheet and PivotTable, but *without the actual PivotTable*. Something like copy/paste values + formatting of the sheet (including headers, footers, layout, etc.).

Any suggestions on how to accomplish via VBA?

 

[DonkeyOte]

see VBE Help Files re: TableRange 1 & 2 (either/or pending pref.) ... with that you can obtain the range to be copied & pasted (values, formats, widths etc...)