CODEWITHSUNDEEP
excelvb.netfilter
cheno
cheno

Reputation: 11

Vb.Net Excel filter

Need a vb.net code to filter excel.

Example filter column 2 by criteria: Apple. All results for apple will now appear within the spreadsheet.

Any help is greatly appreciated.

Thanks

Upvotes: 0

Views: 2074

Answers (1)

Youssri Abo Elseod
Youssri Abo Elseod

Reputation: 771

you can convert following example in your code

'for filter column no 4 for null rows then delete null rows as following
With drywtmonthly.Sheets("input").Range("a1:u1")

    .AutoFilter Field:=4, Criteria1:=""
    Sheet1.Range("a2:u600").Delete

    .AutoFilter Field:=4


End With

i hope it useful

Upvotes: 1

Related Questions