how to fix code for multiple cells to have error message

[3earth]

I found this code and would like to use this will multiple cells.

Please Login or Register  to view this content.

Next cell would be (for example) A2 - Message = You must fill in A2. I have 139 cells that I need to do this for.

Thank you

[alansidman]

try this:

Please Login or Register  to view this content.

[NeedForExcel]

Here!

Please Login or Register  to view this content.

Deep

[NeedForExcel]

But the above code will activate for absolutely any cell.. Are the 139 cells you mentioned about specific?

[MickG]

Try this:-
It will work for cells "A1 to A139"

Please Login or Register  to view this content.

[3earth]

The cells are specific

D8:D22,D24:D37,D39:D46,D49:D58,D60:D82,D85:D121,D124:D155

[MickG]

Try this:-

Please Login or Register  to view this content.