Delete a row based on condition

Hi all,
Thanks to all those who help in the past.

I want to delete a row in excel based on a condition.
The condition is as follows:
I have few rows in the excel where the columns 7,12,13,23 are same and column 24 in one row has some number and in some other row the column 24 is blank with orange color filled(the colorindex for orange is 44).
In this case I want the row with orange color filled in column 24 to be deleted.

Have attached a sample sheet.

Any help on this will be helpful.
Thanks in Advance.

So in your example sheet, the only row to delete would be row 11 based on X11 being orange colored and empty?

Please Login or Register  to view this content.

Thanks JBeaucaire.
Will execute the macro and get back to you soon.

Thanks once again.

Hi JBeaucaire,

Thanks a lot.
The code did exactly what I wanted.
But I want the other column values( 7,12,13,23) same in the rows. and only column 24 to be orange and blank.
The above code does not check if all the other columns a same.

Any help on it will be helpfull.
Thanks in Advance.

I don't actually understand that last part.

Explain further by pointing to your sheet and an example of a row that should be deleted and why. Be specific with your cell references, sometimes I'm dense.

In my sample wookbook, the rows 6 and 11 has same values in columns 7,12,13,23 and column 24 has 07 in row 6 and has orange color filled without value in row 11.
Hence the row 11 has to be deleted.
Since the other columns are similar in rows 6 and 11 and the column 24 has orange filled with blank value in row 11, that row has to be deleted.

Have attached the sample workbook.
Thanks in Advance.

I'm going to refer to columns by their letters, not their numbers, since that confuses the heck out me.

So you want all the values in G5 & L5 & M5 & W5 as a group compared to ALL the other "groups" of values from the same columns...then if their is a duplicate "set", delete the entire row if X5 is orange?

Here's an adjusted version of my original macro. This actually should evaluate much faster on large datasets since we are no longer checking every single row for the orange color, only ones that are flagged to be checked by the duplication key I'm creating in column CC.

Please Login or Register  to view this content.

Thanks for this version of code.
I executed the code, I got a run time error 1004, Method 'Range' of Object '_Global' failed.
in the below line:

Please Login or Register  to view this content.

I dont understand the cause of this error message.

Originally Posted by vijay2482

I dont understand the cause of this error message.

Hehe, you should. There's no such thing as ** in a range reference.

The forum is corrupting my post above. I've tried to fix it twice and it keeps putting ** all through the code. Very odd.

I'll try to post it here:

Please Login or Register  to view this content.

JBeaucaire,

I get the same error in the below line:

Please Login or Register  to view this content.

There is "**" in this line.

Have changed "**" to "CE".
Now it works fine.
Thanks a lot for your kind help.