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

You're limited by the same thing that you see when you do it manually.

In xl2003, there are two criteria.

I sometimes use a helper column with formulas that return true/false and then
filter by that column.



Gary Keramidas wrote:
>
> 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

--

Dave Peterson

ps. Record a macro when you do it manually and you'll see the code that works.

Gary Keramidas wrote:
>
> 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

--

Dave Peterson

thanks dave, i think i'll just build a new report, probably take 10 minutes.

--


Gary


"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> You're limited by the same thing that you see when you do it manually.
>
> In xl2003, there are two criteria.
>
> I sometimes use a helper column with formulas that return true/false and then
> filter by that column.
>
>
>
> Gary Keramidas wrote:
>>
>> 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
>
> --
>
> Dave Peterson