Thanks.


-----Original Message-----
Insert a row at the top, and then a spare column, add

=AND(A2<"",B2=0)

Select this column and Menu DataAuItofilter.
Click the dropdown and select TRUE from the list
Delete all visible rows, including row 1

All done


--

HTH

RP
(remove nothere from the email address if mailing direct)


"rn" wrote in
message
...
Hi

What code can I use to delete rows based on the values
of
two fields/columns on the same row. (if cell A1 is not
blank and cell B1=0 delete)

Thanks.


.