Checking if Cell Data exists in an array

Hello all

I have been working on some code for a spreadsheet solution and have ran into an issue when trying to implement some validation
I am trying to make it so that if the data in a cell is not in an array of names the program will not continue with its functions, but if it is in the array the program will continue as normal. So far I have the following code

Please Login or Register  to view this content.

When I try to run this code, I get an error highlighting "If Weebl.Contains(Range("J10")) Then" and a message box that says "Compile Error: Invalid Qualifier

Is there any way to fix this?

try change to

Please Login or Register  to view this content.

This worked perfectly, thanks for the quick reply