Force Date Entry with Variable Rows, Fixed Columns

Hi
Wondering if anyone can help me with this:

I have a spreadsheet In which columns B through L need to be filled out by the users peroidically.
The problem I am having is that sometimes they do not fill out every column.
What I am trying to do is to develop a simple macro which will check the columns B-L in the activecell row and prompt if any are empty.

I have found a macro which will do exactly what I want except the Range is limited to one cell.

I am having a lot of trouble writing a range for this, any ideas?

Thank you

Hello rlw,

Here is one way to do it...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Originally Posted by Leith Ross

Hello rlw,

Here is one way to do it...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Thank you very much for your reply, your code makes sense to me but for some reason I cannot get it to call the MsgBox, whether there is information in the cells or not.

Any ideas?

Thanks again

Hello rlw,

Looks like a made a typo an left off a closing parenthesis (marked in red). Copy this code. It ran fine when I tested it.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Thanks for your reply again, I had noticed the missing parenthesis but am still having trouble with it. I will keep playing and see if I can find what I am doing wrong, thanks for your help.