Excel functions generally return a value rather than perform an action,
deleting cell values would be deemed as performing an action.

Have you tried using conditional formatting in the cells with values you
want to 'disappear', set the font colour to be the same as the background
colour when the cell value equals zero.
--
Regards - Peter


""The cricket"" wrote:

I generate proposals in Excel. I have a calculation worksheet and a proposal
worksheet. Based on certain product selections, I want to delete the rows of
the products with zero quantities on the proposal worksheet. At the moment it
needs to be done manually, which is tedious. Is there a way to make the rows
with zero quantities "disappear" or be deleted automatically - or on demand?
Any suggestions? (Or will this this require higher level programming?)