Hi,

I want to autofilter data on a master data sheet (pipelineMaster) to another worksheet (Temp). I intend to run the autofilter multiple times and copy paste it on the Temp sheet. When I ran it for the first time, the code worked just fine. But the second time, when I clear the Temp sheet and try to copy autofilter data onto it, I get this error - "Run time error '1004' - Paste method of Worksheet class failed".

Not sure what is wrong with the code as it seems to working just fine in the first time. Entire code is enclosed for your reference.

Please Login or Register  to view this content.