Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
autofilter questions
1. is there a limit to the number of criteria?
2. how do you construct the statement when there is a variable number of criteria? for example, if an array has 3 elements, how do you filter on the 3 criteria. for i = lbound(arr) to ubound(arr) .AutoFilter Field:=1, Criteria1:=arr(i) next i can't figure out to how construct Criteria(i). -- Gary |
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 change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
Answers to questions posing more questions in a workbook | Excel Worksheet Functions | |||
View Questions and Answer to questions I created | Excel Discussion (Misc queries) | |||
Questions: Copy ranges, autofilter macro, subtotals, & naming shee | Excel Programming |