Check if cell value is a number using IsNumeric

[YasserKhalil]

Hello everyone
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

It seems the value is like a number but as for me is not a valid number
How can I skip that problem?
Simply this value shouldn't return True as this is not a real and valid number for me ..

[YasserKhalil]

I have solved it using this line (Evaluate)

Code: Select all

If IsError(Evaluate("" & c.Value & " * 1")) Or IsEmpty(c) Then

But I welcome any suggestions.

[HansV]

You might also use

Code: Select all

If Not Application.IsNumber(c) Or IsEmpty(c) Then

but I haven't tested it extensively.

[YasserKhalil]

An amazing trick my tutor. Thanks a lot.

[Doc.AElstein]

Here are some UDF ideas from Rick Rothstein

[YasserKhalil]

Thanks a lot, Mr. Alan

[LisaGreen]

Here are some UDF ideas from Rick Rothstein

Great thread Alan!

Lisa