How to Copy a filter data with headers, excluding the headers?

Hello,

I am writing macro, I have stopped.

I have a data and I filtered some data specific, then I select the data with visible cells only, but it is selecting the headers, I would like not include headers.

As this macro will be run often, the next visible row after the header can be 5 or can be 96, how I can do that? Some help much appreciated

See my example so far, but this selection is including my header which is Row 1, maybe is another way. I don't want to include the header.


ActiveSheet.Range("A:N").AutoFilter Field:=14, Criteria1:=Array("LOE", "LOE PSNME", "Mbrs", "Mbrs PSNME"), Operator:=xlFilterValues

Range("A1").Select

Range(Selection, Selection.End(xlDown)).Select

Selection.SpecialCells(xlCellTypeVisible).Select

Application.Run "modPaste.Copy"


Thank you

Eliana M

My Macro so far, please advise Thanks Holger

Please Login or Register  to view this content.

Hi Eliana,

Please give a try with below code,

HTML Code: 

py
Please Add Reputation, if you are happy with the help

Hello Holher and PY!! wooow guys you are fantastic! Thanks for all your help.
I was trying to look for the bottom that shows SOLVED and I couldn't find it.

Your help was great!!

Thanks so much... now works... Great!!!