I just noticed posting this message in the wrong discussiongroup *sorry* ...
so here it is in the correc place)

Hi all,

I am currently doing some rapid prototyping in VBA-Excel2003.
Excel is used as lightweight relational database, hence requiring
frequent selection of 'records/rows' based on multiple criteria.

The selections then are transformed into arrays in order to present them in
listboxes.

What is the most efficient/performant way to filter out the relevant
information ?
autofilter ? advancefilter ? find(next) ? for each r in rows - loop ?

tnx in advance,
kind regards,
Bart Wouters