If IsEmpty(Sheet1.Cells(1,1)) then ...
Alok wrote:
You can use the Workbook_BeforeSave event.
In this event you put something like this

if Sheet1.Cells(1,1).Value = "" then
Cancel=True
Endif

"Tammy H" wrote:

In Excel, how can I validate that a cell has data? If there are blank cells,
I would like a message box when the user clicks on file to save or send. Any
help would be greatly appreciated.