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