A particular value?

If Range("A2").Value2 < 17 Then

MsgBx "error"

or any value?

If Range("A2").Value2 < "" Then

MsgBx "error"

--

HTH

Bob

"KP" <none wrote in message
...
Hi,

If cell is not a value I want a messagebox.

I have no problems creating the msgbox, but how do I write the macro
checking for a value?

Thanks for any help.

Kaj Pedersen