VBA: Array - Return common values from two arrays

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

Read more ...

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.

Read more ...

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.

Read more ...