Copy Filtered column data and Paste Special Values to another sheet

I have a VBA macro which filters a table, copies certain columns, and pastes the data into another sheet (one by one)
I am pasting using:

ActiveSheet.Paste

The above works fine to paste the filtered data. But I only want to paste special values so that I do not lose the cell fomatting in the target table.
I tried using

ActiveSheet.PasteSpecial Paste = xlPasteValues

But this returns an error.

Any ideas?

Thanks

I managed to get Paste Values to work by the following:
Selection.PasteSpecial Paste:= xlPasteValues

But I am still losing the cell formatting when the data gets pasted. e.g. accounting cells become numbers, Date cells become text...

Any idea how to keep existing cell formatting when data gets pasted?