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
|