View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Deleting Rows in Excel 2003

There could be.

But how about an alternative.

Add a new column (D) and put:
=countif(a1:c1,0)
and drag down

then apply data|Filter|autofilter
filter to show the 3's.
delete those visible rows
and delete that column.


Gilbert wrote:

Is there a macro that can delete the rows where the value in range a, range b
and range c is equal to zero? In my example below only row 6 would be
deleted.

Range A Range B Range C
Row 1 22 17 18
Row 2 9 10 24
Row 3 1 23 25
Row 4 0 0 26
Row 5 0 29 0
Row 6 0 0 0
Row 7 0 20 8
Row 8 30 28 7
Row 9 21 4 5
Row 10 6 3 14


--

Dave Peterson