.Range.Value Type Mismatch Error

I am able to do this:

Please Login or Register  to view this content.

but if I want to check a range of cells like so:

Please Login or Register  to view this content.

I get a Type Mismatch Error. What is the correct syntax?

You have to check each cell individually. You can however get the system to check a list of cells individually through a loop

Please Login or Register  to view this content.

Ok that's a good idea but this is what I'm trying to do:

Please Login or Register  to view this content.

Is there a way to check for the value AB1234 in the range C5:C9 without having to check the other cells for each iteration?

Cells are checked individually. You want have multiple criteria in your IF statement then you write them all.