Check If Value Exists In Array Help

I have found some online code that I am trying to incorporate into my procedure, however, am having some difficulties.

The code is as follows

Please Login or Register  to view this content.

Rather than having projects defined as a hardcoded array, I was hoping to have this pointing to a range.

My range is cells "B12:B16"

When I set projects to equal this range I always get a not found message.

Please Login or Register  to view this content.

Is anyone able to help?

Thanks

McCrimmon

Hello mccrimmon,

Assign the values to the array rather than the cell object . I know that the value of a Range object is the default property, but you must explicitly state this when making an array.

Please Login or Register  to view this content.

It works for me without using the Value property (I do agree with Leith that omitting the Value property is sloppy).

Note that when you create the array here:

Please Login or Register  to view this content.

it is a 1-D array.

But when you create the array here:

Please Login or Register  to view this content.

it is a 2-D array.

When I set projects to equal this range I always get a not found message.

When you step through your code using F8, after the array of values has been assigned to Projects, can you see BM01 when you expand Projects in the Locals window? If not, perhaps you are pointing at the wrong sheet and should qualify the Range property:

Please Login or Register  to view this content.