Related:
- Excel 2003 VBA code for filtering
- Battery reset code - Guide
- Samsung volume increase code - Guide
- Usa country code for whatsapp - Guide
- Number to words in excel formula without vba - Guide
- Cs 1.6 code - Guide
1 response
bloodveyors
Posts
4
Registration date
Saturday March 21, 2009
Status
Member
Last seen
June 16, 2009
1
Mar 25, 2009 at 07:37 AM
Mar 25, 2009 at 07:37 AM
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
Jan 17, 2010 at 09:16 PM
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.