Thanks Dnereb. In my application however, I do not know how many rows of
entries will be made on the sheet. Perhaps I need to enter the formula in all
columns. But then, if the code is to prevent further action till the blank
value is filled in, the cells in the yet to be filled rows will also swing
into action to jam the works. It would have been great if, on getting focus,
the data validation took over.
Jai

"Dnereb" wrote:


check for len(cells(X,Y)) = 0
I dont know if you are using a formula or VBA but this will be the
general concept


--
Dnereb
------------------------------------------------------------------------
Dnereb's Profile: http://www.excelforum.com/member.php...o&userid=26182
View this thread: http://www.excelforum.com/showthread...hreadid=396909