Hello,
I use range to select data in a column.
If the selection is empty I want to execute a row in the sub, then jump to another row in the sub and continue the sub from there to the end.
If the selection is not empty I continue the sub without doing the row above.
I have tried but cannot make it working.
How can this be done?
The selection is made by,
ActiveSheet.Range("$A:$AC").AutoFilter Field:=20, Criteria1:=">=2017011", _
Operator:=xlAnd, Criteria2:="<=2017052"
I use range to select data in a column.
If the selection is empty I want to execute a row in the sub, then jump to another row in the sub and continue the sub from there to the end.
If the selection is not empty I continue the sub without doing the row above.
I have tried but cannot make it working.
How can this be done?
The selection is made by,
ActiveSheet.Range("$A:$AC").AutoFilter Field:=20, Criteria1:=">=2017011", _
Operator:=xlAnd, Criteria2:="<=2017052"