Validate Number or string

Question

Quick question: I have a cell that can have as value or a number or the string "NN"

I wrote this line of code:

If Not IsNumeric(Cells(c, 64)) Or Cells(c, 64) <> "NN" Then
    errCell.Value = "Wrong Div"
    errCell.Interior.Color = RGB(255, 0, 0)
    GoTo Boucle
 End If

I apply to a cell which is a number But I get an error... Any lead would be great Thank you

I have a the Wrong Div message ... basically the macro compiles well but it should not specify this error since the cell is a number — sharkantipav
– sharkantipav, Commented Mar 14, 2014 at 16:43
Of course it should, the right side of the OR returs true so it writes "Wrong Div", maybe you want to replace OR by AND — CRondao
– CRondao, Commented Mar 14, 2014 at 16:47

Aidan · Accepted Answer · 2014-03-14 16:48:52Z

1

I think you have a logic error - as it stands the error message is always shown. Try:

If Not IsNumeric(Cells(c, 64)) AND Cells(c, 64) <> "NN"

answered Mar 14, 2014 at 16:48

Aidan

1,8101 gold badge16 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Validate Number or string

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related