VBA Copy autofiltered range without header

[mikekhel1987]

I want to copy the filtered data and paste it in difference excel worksheet. I am able to filter , copy and paste the rows. The only problem I am facing is that it is also copying and pasting the header every time. Please advise as to how to avoid header to be pasted. Below is the code that I used.

Please Login or Register  to view this content.

Appreciate any help from you guys. Thanks

[leelnich]

Quick answer, just delete the extra row. There may well be a more elegant solution.

Please Login or Register  to view this content.

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

[WasWodge]

Crossposted without a link here ​