Macro help

[AussieVic]

Hi would like to add a condition to the below code, when the code filtersinplace but there is no data to filter then do no proceed in copying to destination.



ShtTemp.Range("A5").CurrentRegion.AdvancedFilter Action:=xlFilterInPlace, _
Criteriarange:=Range("rngAsset"), Unique:=False


ShtTemp.Range("A5").CurrentRegion.Offset(1).Resize(, 14).Copy Destination:=shtAsset.Range("A6")

 

[AussieVic]

Your original question: "Sektor will this exit sub if there is no data so the code does not keep running?"
I wrote code which makes Sub terminate when there's no data. When do you want to exit? Please, be more specific.

That is correct, but when i run the code it does not jump to Exit sub if there is no data