I have a value in a cell like that
1,,6
And in the code I have used
Code: Select all
If Not IsNumeric(c) Or IsEmpty(c) Then
How can I skip that problem?
Simply this value shouldn't return True as this is not a real and valid number for me ..
Code: Select all
If Not IsNumeric(c) Or IsEmpty(c) Then
Code: Select all
If IsError(Evaluate("" & c.Value & " * 1")) Or IsEmpty(c) Then
Code: Select all
If Not Application.IsNumber(c) Or IsEmpty(c) Then
Great thread Alan!