N Newbie Aug 3, 2012 #1 I would like to show only rows where column E (5?) is not zero. Can anybody show me how to do that?
C Claus Busch Aug 3, 2012 #2 Hi, Am Fri, 3 Aug 2012 09:50:51 -0700 (PDT) schrieb Newbie: I would like to show only rows where column E (5?) is not zero. Can anybody show me how to do that? Click to expand... ActiveSheet.Range("A1").AutoFilter Field:=5, _ Criteria1:="<>0", Operator:=xlAnd Regards Claus Busch
Hi, Am Fri, 3 Aug 2012 09:50:51 -0700 (PDT) schrieb Newbie: I would like to show only rows where column E (5?) is not zero. Can anybody show me how to do that? Click to expand... ActiveSheet.Range("A1").AutoFilter Field:=5, _ Criteria1:="<>0", Operator:=xlAnd Regards Claus Busch