Use the deactivate event

http://www.cpearson.com/excel/events.htm
Chip Pearson's page on events.

--
Regards,
Tom Ogilvy

"Spyder" wrote in message
...
Does anyone have an example of code I might use with
"worksheet_selectionchange" to prevent a user of my workbook from leaving
cells null withing a specific range? Note that users may add rows to the
middle of the range, but none of the cells in the added rows withing the
range should be null. Ideal case would result in a pop-up when the user
tried to leave the worksheet.

THANKS FOR ANY DIRECTION!!