Delete rows based on the list of unique identifiers created

[Andy308]

Hello forum,

Hope you guys are having good time there!

I have a workbook with data up to 10000 rows, all we need is to create a list of unique identifier and VBA codes that can delete the rows that contains the unique identifier in it.

Below unique identifier list -
Madilu
Bg pura
Nandhi

So for example in cell b7 there might be the word nandhi: when macro is run row 7 should be deleted. Similarly cell c 9 might contain word madilu so when macro is run row 9 should be deleted!
Unique identifier should be matched in both column b and column c of the sheet and first run on column b and delete the found/matched and again run on column c deleted the mached rows with list above. If able to run on both the rows simultaneously then it is better.


Note- if possible to include multiple conditions (in this example 3 from the above list) to run at one go it is better.

[1aaaaaaaaaaaaaaa]

Do you have a workbook I can test with?

[Andy308]

Currently I am unable to access computer to send sample file. If it is needed then I will see and it tomorrow! Thanks for looking into Poizhan!

[1aaaaaaaaaaaaaaa]

Ok, try this, I think this is what you are looking to do.

Please Login or Register  to view this content.

[Andy308]

I tried using this code, however Iam getting an error message as “Run – time error ‘91’, Object variable or with block variable not set” and code stops to run in line rng.Select . I guess this is because the cells in column A are merged. I have attached the sample file and updated the keywords. Please help on this issue to be fixed.

[1aaaaaaaaaaaaaaa]

Seems your data does not start on row 1, is this on purpose?

[1aaaaaaaaaaaaaaa]

Modified code

Please Login or Register  to view this content.

[Andy308]

Thanks Poizhan! It worked perfect now, let me mark the thread as closed.

[1aaaaaaaaaaaaaaa]

Thanks Poizhan! It worked perfect now, let me mark the thread as closed.

You're welcome, God bless you my friend