missing number find

  • Thread starter Thread starter theo
  • Start date Start date
T

theo

If I need to find a missing number in a list say numbers 1 to 10 and
number 8 does not appear in the list can excel identify the missing
number and show it to me
 
see how this works
Sub findmissing()
On Error Resume Next
For Each c In [k1:k9]
If c + 1 <> c.Offset(1) Then
MsgBox c + 1 & " missing"
c.Select
End If
Next
End Sub
 
Back
Top