IsEmpty Help for multiple Cells

Hi,

In the spreadsheet I am working on, I have 2 different sets of Contacts:

Contact 1 = cells E55 (Con1) and E59 (Con2)
Contact 2 = cells E77 (Con3) and E81 (Con4)

I have code so that if all the cells are blank, then a MsgBox will pop up (thanks to ArkAdi for the assistance )

However, I need to expand this so if one of the 2 cells in each contact group (e.g. Contact 1 or Contact 2) is blank that a MsgBox will pop up giving a warning. (e.g. If Con1 <> 0, but Con2 = 0 & Con3 and Con4 =0 - MsgBox stating that Con2 is Blank)

The following code will warn if all cells are blank, but then also runs the individual cell check. Or if one of the cells isnt blank, then it will run the IsEmpty code only.

Please Login or Register  to view this content.

Hopefully I have explained what I need clearly enough and thank you in advance,

Chris

Try

Please Login or Register  to view this content.

Hi Leigh Ross,

Thank you very much for the code, works a treat. Plus I learned about Xor....

Chris

Hi jindon,

Thank you very much for the simplified code - bit beyond my comprehension at the moment but hope to get to that level

Chris

You are welcome and thanks for the rep.

Is is a very simple code so I hope you will understand easily.