Hi all,

I have a macro statement that, if a field in a certain column is blan
it will look to another column in the same row, and if that fiel
contains a certain name it will delete the entire row. I want
statement that will NOT delete the row if it contains a certain name
i.e. if any field in col E is blank look to col D and delete the entir
row if it does not contain Mark, Brian and Karl.

Can anyone please help me on this??

Thanks in advance,

Cathal

--
Message posted from http://www.ExcelForum.com