Delete rows based on values in a column

[Motox]

Hi,

I have three columns of data (Columns A, B and C). Row 1 of each is used for a heading.

Column B contains either “AB” or “RL”.

I want to delete any row that contains “RL” in column B.

What VBA code can I use that will detect rows with “RL” in Column B and delete them?

Please see attached example.

Thanks very much

Dave

[Debraj Roy]

Hi Dave,

as a starting level, you can use below code to delete each row by checking one by one..

Please Login or Register  to view this content.

But if you are in hurry, you can use below code too..

Please Login or Register  to view this content.

[brynbaker]

That looks sharp to me but I added a general note: when deleting columns (or rows) always start at then end and move up (to the left) using step -1 as here. It's faily obviouss after yov'e spent some time debugging the wrong soltion.

[satputenandkumar0]

Dear Motox,

user below code.

Please Login or Register  to view this content.

Regards,
Nandkumar S.

[Motox]

Hi,

Thanks all for your help.