B
Bart Wouters
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
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