VBA Filter?

N

Newbie

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered view of Visio Chart 0
Need Help with a VBA subroutine 0
sqlite-odbc write conflict 2
Word VBA - Want to test if Full Name is NOT Present in document 0
Drop down list control value in vba 2
Consolidation Table from Different Excel Tabs with Different Format 1
Scroll does not show preview 0
Help with copying a sheet from One workbook to another workbook 1

Top