Hi |
Would someone be able to help with the VBA code if cell does not contain "data" the go to next code? |
Eg: skip cell does not contain "Asset" the go to next code cell contains "Same"? |
I have the below code which I use to generate cell range contains "asset" |
ActiveSheet.Range("$A$1:$AA$76").AutoFilter Field:=22, Criteria1:= _"=*Asset*", Operator:=xlAnd |
''''' do stuff''''''''''' |
i want the code above to if not found go to next code |
Sub within_PO() |
ActiveSheet.Range("$A$1:$AA$76").AutoFilter Field:=22, Criteria1:= _"=*Same*", Operator:=xlAnd |
Thank you so much |
<tbody>
</tbody>