Hi
see your reply in Excel.misc :-)
--
Regards
Frank Kabel
Frankfurt, Germany
I have around 3000 rows of data
If the background color of the cell in Col B is light blue (in the
color palette, col 7 , row 4) , then it should delete the row
thank you
---
Message posted from http://www.ExcelForum.com/