Delete Additional Rows

I'm using this piece of code (as part of a macro) to delete rows 28 to 62 when the values in column F are zero. In addition to this, I want to be able to also delete rows 20 to 27, when the value in C22 is "-". Is there a way to achieve this bearing in mind that not all rows in the range C20:C27 will show "-" ?

Please Login or Register  to view this content.

Many thanks

Maybe:

Please Login or Register  to view this content.

Hi Martin,

However much I adjusted the row number in the code I couldn't delete row 20! Not sure what I am doing wrong...

Hi xladept

That worked perfectly and does delete row 20... still unsure why I couldn't do that with Martin's code, but all working I think!

Many thanks

You're welcome, I can't imagine why Martin's code didn't work, except if you ran it before the other deletions

No, I ran it in the same place as your code, kept adjusted the row references but couldn't get row 20 to delete. It will be because it's late and I've been staring at this for too long. I'm sure it does work, it's just me