I have a sheet which I want to filter with a macro.
I want to filter on column 11 who has the number 1 in it.
I have made the following macro,but he gives
me an error.What is wrong?
Sub Filter()
Selection.AutoFilter Field:=14,Criteria1:="1"
End Sub
Many thanks
I want to filter on column 11 who has the number 1 in it.
I have made the following macro,but he gives
me an error.What is wrong?
Sub Filter()
Selection.AutoFilter Field:=14,Criteria1:="1"
End Sub
Many thanks