check cells

Hello Fotis1991,

Thanks for your reply.

The data in file is sensitive,so i have mocked up a dummy sheet example.

I have attempted to write some code myself but i am no programmer
but it will give me the msgbox when there is a cell empty in the range
but it seems to go into an infinite loop.

I would think my code is a mile off what is needed.