I tried using Selection.Paste, but it gives me same error. Any other advise?
Does applying filter  and then copying and pasting to another workbook  could be a
problem? Because the Activesheet.Paste is used for another report which does not
require applying a filter works fine.