ok
could you upload a workbook? that would make helping you a lot easier

btw, do you want the rows actually removed or is just appearing empty through a formula also ok?