Pivot table selection not Copy/Pasting to Destination Cells

[Anniemack]

I am trying to copy a column from a pivot table and paste in a different workbook location. It appears to highlight the proper cells in the pivot table, but when it pastes, it pastes blanks!

I'm at a loss of how to even debug the dang thing. Any help would be greatly appreciated!

Application.CutCopyMode = False

wf_pt.PivotSelect "Program Title[All]", xlLabelOnly, True
    Selection.Copy
    ws_set.Range("comms_top10").PasteSpecial xlPasteValues

 

[mrshl9898]

All seems to be working for me.

Can you see the data is being copied? Is

[COLOR=#333333]ws_set.Range("comms_top10").Select[/COLOR]

Selecting the correct range to paste into?