Maybe apply Data|Filter|autofilter
show that value and delete the visible rows.
and show all the data
Recording a macro when you do it manually will give you the code.
elkins wrote:
I would like to delete a row if the value in a column is zero. How
could I do that with a simple macro? I am not that savvy when it comes
to Excel.
Thanks
--
elkins
------------------------------------------------------------------------
elkins's Profile: http://www.excelforum.com/member.php...o&userid=27707
View this thread: http://www.excelforum.com/showthread...hreadid=473963
--
Dave Peterson