.Range.Value Type Mismatch Error

I am able to do this:

If .Range("C5").Value = "AB1234" Then

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

If .Range("C5:C9".Value = "AB1234" Then

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

for each rng in range("C5:C9")

if rng.value = "AB1234" then 
'Do something
end if
next

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

        For Each Rng In Range("C5:C9")
            If Rng.Value = "AB1234" Then
            'Do nothing
            End If
            next
        .Cells(5, 4).Value = "AC1234" And _
        .Cells(6, 4).Value = "AD1234" And _
        .Cells(7, 4).Value = "AE1234" And _
        .Cells(8, 4).Value = "AF1234" Then

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.