I have a macro that uses AutoFilter to filter a list on one sheet. I then use
to paste the filtered data to a second sheet.
However, I receive an error message saying that the Method Paste failed even though
the data does seem to be copied correctly.
I've tried using Activate rather than Select for the Calculation sheet, but still receive
the error message.
What am I doing wrong? Thanks, Andy.