How do I declare an array variable in VBA? - Stack Overflow

A dynamic array is one whose size is not specified in the declaration ( Dim ... You have to declare the array variable as an array: ... Excel vba search in array.

stackoverflow.com