Wednesday, 26 September 2012

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.

1 comment:

  1. Hi , I try this code But I have a error "ByRef argument type mismatch" ,Do you know Why It is happen .