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.
|