The below function will return the common values that are exist in two different arrays. This can be achieved by nested-looping concept, but this is an effective way :).IsInArray is an another function. Dont forget to include it.
aa
Showing posts with label Array. Show all posts
Showing posts with label Array. Show all posts
Wednesday, 26 September 2012
VBA: Distinct Array items - Remove duplicates
If you have an array with repeated items and want distinct items, then copy the below source code. IsInArray is an another function. Dont forget to include it.
VBA: IsInArray - Find a value in array items
The below script will be used to get to know whether a particular item exists in a array or not. Instead of looping this would be faster.
Subscribe to:
Posts (Atom)