Macro to delete entire roll when the cell has "CLOSED" text

[ricdamiani]

Hi guys,

It is pretty simple: the macro needs to delete the entire roll (or rowS when find more than 1) when find the text "CLOSED" in the column H, in the sheet "Orders".

I found a similar code in the net:

Please Login or Register  to view this content.

Any idea?

Thanks folks

[:) Sixthsense :)]

delete the entire roll (or rowS when find more than 1) when find the text "CLOSED"

Still the above quoted line is not clear to me Can you please explain it....

[ag273n]

try this:

Please Login or Register  to view this content.

btw, when you said delete, do you mean clear the contents of the row? or delete the entire row and move up the rest? .... if this doesn't work.. please post a sample file..

[ricdamiani]

Still the above quoted line is not clear to me Can you please explain it....

Hi Sixthense,
Thank you for your replay

In my sheet I have several rows, and in the column H it will be or "OPEN" or "CLOSED" written inside the cell.
The macro will delete the rows which has the text "CLOSED" into the cell.

Did you understand? If you want I can do a sample sheet for you

[ricdamiani]

try this:

Please Login or Register  to view this content.

btw, when you said delete, do you mean clear the contents of the row? or delete the entire row and move up the rest? .... if this doesn't work.. please post a sample file..

Hi ag273n,
Thanks for the raply as well

Yes I mean delete the entire roll.
The macro worked partly.

It deleted 2 in 2 rows...

Did you understand? If you still didn't get the idea let me know and I will attach a sample for you

[:) Sixthsense :)]

Thanks for the brief, try the below code...

Please Login or Register  to view this content.

[ricdamiani]

Yes it is working!
Thanks sixthsense

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback