| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Filter-VB
Can you use Auto Filter w VB to display only certain years in a spreadsheet
?? I have 3 columns/70 rows with 4 different years ( MM/DD/YYYY). I'm trying to figure out how to set the auto filter to only show 2007 , do some calculations then only display 2008, do some calculations etc. using VB Selection.AutoFilter Field:=1, Criteria1:="2007" Thanks, Clint |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel auto-filter does not filter certain columns | Excel Discussion (Misc queries) | |||
| DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
| Excel 2007 Auto Filter Filter | Excel Discussion (Misc queries) | |||
| ranging the filter cells when doing auto filter | Excel Programming | |||
| Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
![Clint Eastwood[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
