danovkos
09-07-2009, 03:10 AM
Hi all,
pls. how can i define in code, that i want to select the last (without "blank", "Nonblank" - those are the last) from filter criteria? Because i dont know, what will be the last data, i want to define - use the last in filter combo.
i have this code:
Sub SAP_Kries12_old()
Sheets("aktual").Select
If ActiveSheet.FilterMode Then
ActiveSheet.ShowAllData
End If
Selection.AutoFilter Field:=8, Criteria1:="<3", Operator:=xlAnd
End Sub
thank you
pls. how can i define in code, that i want to select the last (without "blank", "Nonblank" - those are the last) from filter criteria? Because i dont know, what will be the last data, i want to define - use the last in filter combo.
i have this code:
Sub SAP_Kries12_old()
Sheets("aktual").Select
If ActiveSheet.FilterMode Then
ActiveSheet.ShowAllData
End If
Selection.AutoFilter Field:=8, Criteria1:="<3", Operator:=xlAnd
End Sub
thank you