I have tried and tried to create a MACRO in Excel that will will delete
a row. I have read several other marcos but have been unable to
translate them to what I want to do. Listed below a sample of the type
data I am talking about. What I want to do is have the macro read the
second number in the colum and everytime it read a 0 it deletes that
whole line of information. This type table will have some blank row
but I do not want to delete. Can anyone help. Thanks in advance. Ron


D60801 0 0 0 0 0
D78555 0 0 0 0 0
E98103 0 0 0 0 0
N04456 0 0 0 0 0
N05482 3 60 0 0 0
N95862 0 0 0 0 0
N96248 3 8.25 0 0 0


R59160 0 0 0 0 0
R67908 0 0 0 0 0
R67976 0 0 0 0 0
R68044 3 204 0 0 0


--
Duster142
------------------------------------------------------------------------
Duster142's Profile: http://www.excelforum.com/member.php...o&userid=27738
View this thread: http://www.excelforum.com/showthread...hreadid=472470