Related:
- Excel 2003 VBA code for filtering
- Excel vba find - Guide
- Excel mod apk for pc - Download - Spreadsheets
- How to open vba in excel - Guide
- Excel vba timer - Guide
- Cs 1.6 code - Guide
1 response
bloodveyors
Posts
4
Registration date
Saturday 21 March 2009
Status
Member
Last seen
16 June 2009
1
25 Mar 2009 à 07:37
25 Mar 2009 à 07:37
hi,
try this link to see if it helps you:
http://www.ehow.com/how_4501336_use-auto-filter-microsoft-excel.html
try this link to see if it helps you:
http://www.ehow.com/how_4501336_use-auto-filter-microsoft-excel.html
17 Jan 2010 à 21:16
The real answer is to combine the ">=" operator with your source cell so that it reads like this:
Range("I11").Select
Selection.AutoFilter
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 3
Selection.AutoFilter Field:=9, Criteria1:=">=" & Range("E6")
Hope this helps.