Check Multiple Cells in a row for blanks!

[O177812]

Trying to generate a message box if any cells in a range are blank.

This is what I have but is not working.

If IsEmpty(Range("A31")) = False And Range("C31:P31") = "" Then
MsgBox "Your are missing some information for this item"
Range("C31").Select

Basically if an item is listed in column A. I want the macro to stop and a message box appear if all of the subsquent information about that item has not been entered in columns C thru P.

Any assistance would be greately appreciated!

 

[Fluff]

Duplicate to: If Cell A is not blank and Cell B is blank then......

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.