| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
customize AutoFilter
im trying to set autofilter to use a specific range...from what i have
learned of VBA, this seems like it should work...but it doesnt.... Range("A3").Select Selection.AutoFilter.Range("A7:A" & Range("EndOfProducts").Offset(-1, 0).Row) how can i get autofilter to use that range for its data.... (also as a bonus question...is there a way to toggle the autofilter options? i would like to disable Top 10, and Custom) Thnx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
| 2007 excel autofilter back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
| 2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
| 2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
| How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) | |||
![Nigel[_27_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
