Is the cell numeric : IsNumeric « Data Type Functions « VBA / Excel / Access / Word






Is the cell numeric

 
Sub ResetTest2()
    For Each n In Range("A1:A8")        '   Substitute your range here
        If IsNumeric(n) Then
            n.Value = 0
        End If
    Next n
End Sub

 








Related examples in the same category

1.Use IsNumeric to check the input value