Quote:
Originally Posted by Bruno Campanini
The small routine I added (Private Sub Workbook_SheetChange())
works that way:
every time you change a value in a A:J range of the sheet, the code
checks the D cell for zero value and sends a message.
It's not practical: may be you want D cell to be checked after completion
of A:C range, or something like that.
You didn't give enough info...
Bruno
|
Hi,
Thanks for the help... I want Excel to show a error message if cells D9 till D16 are "Empty". A simple error message which says "Please fill empty cell in" would be fine.. I did already state this in my first message.
Thank You.