Filter Function for 2-dimensional array
 

In vba, they've provided a Filter function as described below. Is there
any other built-in functions or ways that can do with 2-dimensional
array. I would like to pickup some rows in an array just like SELECT
statement in SQL.

Thanks,


------------------------------------------
Filter Function

Description

Returns a zero-based array containing subset of a string array based on
a specified filter criteria.

Syntax

Filter(sourcesrray, match[, include[, compare]])


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Filter Function for 2-dimensional array
 

for a VBA array - no.

--
Regards,
Tom Ogilvy

"Cool Sport" wrote in message
...
In vba, they've provided a Filter function as described below. Is there
any other built-in functions or ways that can do with 2-dimensional
array. I would like to pickup some rows in an array just like SELECT
statement in SQL.

Thanks,


------------------------------------------
Filter Function

Description

Returns a zero-based array containing subset of a string array based on
a specified filter criteria.

Syntax

Filter(sourcesrray, match[, include[, compare]])


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Filter Function for 2-dimensional array
 

I think I should loop through the array then check values on Filter
field using Like operator.

Thanks anyway,

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Filter Function for 2-dimensional array
 

You could use an ADO recordset. Think of it as an in-memory array with
some useful properties and methods, including Filter. It can work
disconnected from its data source, can even be fabricated from scratch
(i.e. no data source), saved to disk (e.g. as xml) and later reopened,
can be multi-dimensional to create hierarchies (a recordset of
recordsets) etc. I rarely use arrays these days!

Jamie.

--