K
KR
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
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