Not possible, formulas can never delete anything, you could sort of hide it
using white fonts and conditional formatting but to delete you would need an
event macro


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Jen" wrote in message
...
I need to create a formula that will delete a line in one worksheet when a
cell in another worksheet equals zero.