Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advanced Filtering criteria
Is it possible to write the criteria for advanced filtering in VBA code
rather than put it in a range? It doesn't appear that you can type a single number in as criteria. I'm going to be filtering different large spreadsheets each week for the same criteria and I don't want to add any more rows to the workbook. Thanks, Lee |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advanced Filtering criteria
Hi Lee
You can use a other workbook to store the criteria My new Filter Add-in is doing that also http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl "FinChase" wrote in message ... Is it possible to write the criteria for advanced filtering in VBA code rather than put it in a range? It doesn't appear that you can type a single number in as criteria. I'm going to be filtering different large spreadsheets each week for the same criteria and I don't want to add any more rows to the workbook. Thanks, Lee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Filtering | Excel Discussion (Misc queries) | |||
Advanced Filtering | Excel Discussion (Misc queries) | |||
advanced filtering multiple criteria | Excel Discussion (Misc queries) | |||
Advanced Filtering - Computed Criteria | Excel Worksheet Functions | |||
advanced filtering | Excel Programming |