Delete rows based on values in a column

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

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.

Hi,

Thanks all for your help.