Error 1004, When I am trying to check a range for certain pattern

[CMVasquez]

Here is the code in my macro that I would like to use to check cell range D4:O4 for the pattern FY followed by two numbers. Any help would be appreciated.

If Range("D4:O4").Value <> "FY##" Then
MsgBox "please check your FY's."
End If

 

[Fluff]

Hi
How about

    Dim Cl As Range
    For Each Cl In Range("D4:O4")
        If Not UCase(Cl.Value) Like "FY##" Then
            MsgBox "please check your FY's."
            Exit Sub
        End If
    Next Cl

This will accept FY & fy. if you want it to be case sensitive replace the if statement with

        If Not Cl.Value Like "FY##" Then

 

[CMVasquez]

This works perfectly, you're a life saver.
Thank You!

 

[Fluff]

Glad to help & thanks for the feedback