Check a range of cells for empties

[coachdave]

Hi,

Upon deactivation of a worksheet I am trying to check a range of cells("B8:M8") for empties. If any cells are empty I want to generate a MsgBox that asks the user to remedy the situation. It is not necessary to tell them which cell is empty but it would be nice. Can anyone help me format this code?

Thanks in advance.

[StephenR]

Try this in the sheet module (right-click sheet tab, View Code, paste):

Please Login or Register  to view this content.

[coachdave]

Thank you very much. It worked perfectly. Being only knowledgable enough to be dangerous I never would have figured this out.

Thanks again