A function can do one thing: it can return a value.
It cannot format, it cannot copy/paste, delete.insert, on any other Excel
feature
Do you wish to delete all rows in a worksheet when the A cell is empty?
A VBA subroutine can do this; let us know exactly what you need
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"aditya" wrote in message
...
Is there any function to delete entire row if a cell is empty like this

=if(A1="",delete row1,"not empty")