Hi,

I basically want to search for any chracters other than numbers and semi-colons from Row 2 and column D to column AG and to put up an error if detected. Ive used this as an e.g but it only picks up numbers greater than 7. I want this but also any character other than a semicolon.
Thanks


For Each c In Range("d2", Range("d65536").End(xlUp))
    If Not IsEmpty(c) And c.Value > 7 Then
        If MsgBox("Order of Entry; You have a number higher than 7 in cell " & c.Address, 1, "Out of Parameters") = vbCancel Then
            c.Select
            Exit Sub
        End If
    End If
Next c