Hello,
I have a column containing empty cells, cells with value zero and a variable number of variable values. I want to make a filter which only shows the values that are not zero or not blanks.
This is part of a larger VBA macro, but the specific selection looks like following:
ActiveSheet.ListObjects(Range("M1").Value).Range.AutoFilter Field:=9, Criteria1 _
:="<>0", Operator:=xlOr, Criteria2:=
I cannot find the way to define the second criteria. In Access I would state NotNull but that doesn't seem to work in Excell. Can anyone help me out?
Thank You.
Bookmarks