Answer by
hwht25 (441)
Well you have to go to edit and then select your pivot table and then copy and paste according in the VBA. This should work fairly well or do a print screen of your table and then take into paint. Then from paint you want to select the table and copy and paste into VBA.
