macro filter question

[plost33]

I use the following line of code to apply a filter to my data.

.AutoFilter Field:=5, Criteria1:=Myval


I want to apply a second filter to several other columns. fields 2,3,4,6,7 and 8. i want that filter to be for cells with values/non blank cells. how could i expand this filter to emcompass both levels of filtering.

 

[texasalynn]

just add to the macro
.AutoFilter Field:=2, Criteria1:="<>"
.AutoFilter Field:=3, Criteria1:="<>"
.... and so on