Excel VBA - Filter Using VBA
A reference snippet on how to apply filter the spreadsheet on for a predetermined column.
Option Explicit
Public Sub OrderColumn()
With ActiveWorkbook.Worksheets("Juice")
If .AutoFilterMode Then .AutoFilterMode = False
With Range("B2")
.AutoFilter
.Sort Key1:=.Range("A1"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
End With
End With
End Sub
Watch video Excel VBA - Filter Using VBA online without registration, duration hours minute second in high quality. This video was added by user Rabi Gurung 26 November 2018, don't forget to share it with your friends and acquaintances, it has been viewed on our site 431 once and liked it 0 people.