Hi Jan,


I'd like to remove values in cells (not cells) in column
A that don't
contain a 10digit number.


try

For Each cell In Range("whatever")

If (cell.Value Mod 1000000000 = 0) Then
cell.Value = ""
End If

Next cell


Best

Markus