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?