If cell is null then...

[mike02]

I cannot get this to work for some reason. What i need is an If statement. I checks the contents of the Cell "N9". If nothing is enetered. IE empty, Null. Then I need it to display a msgbox saying, please enter a company ID.

Here is what i have:

Please Login or Register  to view this content.

Thanks,

[dilipandey]

HI Mike,

Try using below code:-

Please Login or Register  to view this content.

Regards,
DILIPandey

<click on below 'star' if this helps>

[mike02]

thanks for your help

[dilipandey]

You are welcome..

Cheers

Regards,
DILIPandey

<click on below 'star' if this helps>