excel 2003 using more than two criteria in a autofilter

[vbapadawan]

gidday all

is there a way to create an array or something that would allow the user to activate an autofilter with more than two criteria in Excel 2003?
i would like to use a listbox on a userform, but am open to suugestions

thank you in advance

[jaslake]

Hi vbapadawan

In Excel 2007 and up one can Filter on an Array. Prior to that the limit is two Criteria.

[vbapadawan]

bugger, i thought so...

Hi vbapadawan

In Excel 2007 and up one can Filter on an Array. Prior to that the limit is two Criteria.

[jaslake]

Hi vbapadawan

If you're stuck with Excel 2003 the best I can suggest is doing multiple Filters and copy resulting Visible Cells to a new worksheet that would contain the cumulative results of each Filter.