IF(ISNUMERIC... (like the worksheet formula)"Curious, because IsNumeric is the vba version while ISNUMBER is theworksheet function.SoIf Selection.Value = "2" Thenmight become:If IsNumeric(Selection.Value) Then(untested)