I need to find out if certain values are in one part of a multidimensional
array. In the past I've used application.match against 1-dimensional arrays
to see if it throws an error (which tells me it isn't in the array).
Unfortunately I can't find any help for match or application.match in the
VBE help. Using XL2003 on Win2000.

Can I do the same thing with a multidimensional array, and if so, what is
the proper way to identify the array in the match? e.g. should I just have
the array name
(MySource())
or do I need to specify the part of the array to search
(MySource(1,))

Or do I have to copy the part of the array where I want to check for matches
to a new 1-D array? That would be inefficient, since I'll be looping and
adding hundreds (maybe thousands) of entries...but I have to find the
matches (or lack thereof), so I'm open to options.

I'd prefer not to deal with collections if there is a way to keep all this
in my array.

Thanks!
Keith

--
The enclosed questions or comments are entirely mine and don't represent the
thoughts, views, or policy of my employer. Any errors or omissions are my
own.