try

for i =cells(rows.count,"al").end(xlup).row to 2 step -1
if cells(i,"al")=0 then rows(i).delete
next i

--
Don Guillett
SalesAid Software

"phil2006" wrote in
message ...

Can anyone help me write a macro that deletes the entire row if the cell
in the corresponding row in column AL = "0" ?

Thanks

Phil


--
phil2006
------------------------------------------------------------------------
phil2006's Profile:
http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=566272