View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default delete row based on column value??

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