Hi nepotist,

Your solution worked, thank you.

For yourself or others that may be able to help, can this code be modified to give a friendlier messagebox, i.e the column headers rather than for example $A2$ and such like. It would be easier for the user to read. My headers are all on row 2.

Lastly, can the user be coaxed back or forward to the last (or next) "missed cell. I am just trying to setup a "do not pass go!" unless you fill it all in environment.

I can imagine it is a bit tricky, and I wish work had Access!

Any more help (or requests for me to explain myself a better) much appreciated. This is my last hurdle!