something like
for each c in selection
if c.interior.colorindex=6 then c.rows.delete
next

--
Don Guillett
SalesAid Software

"Amber" wrote in message
...
In my spreadsheet I have yellow lines that say result. I want to delete
these lines. How would I do this?