Help! Please- need to delete row if column AD does NOT contain the letter A or B

[PLEASEHELPASAP]

Help please!

I want to delete the entire row if Column AD DOES NOT have the letter A or B.

Therefore, if COLUM AB has the letter A or B, IT WILL REMAIN.

PLEASE HELP! THANKS!

-Amber

[carrob]

This is untested by try it out:

Please Login or Register  to view this content.

whenever the sheet is updated this code will run (so to make it run for the first time change something in the sheet anywhere). Do not put this in a module, put it in the corresponding sheet and make sure to change the Sheet 1 to your sheet title.

[PLEASEHELPASAP]

I'm a total beginner and read your post 3 times and still don't understand :-\

[oeldere]

You also asked this on another topic. See below.

http://www.excelforum.com/excel-prog...html?p=2882399

[PLEASEHELPASAP]

Yeah, because I told you that I didn't understand your explanation, try again, with something easier maybe, please.

[oeldere]

Received a personal mail

Please Login or Register  to view this content.

Maybe you can start to add an example.

You get better help if you post an Excel-example of your workbook, without confidential information.

Then i will look if I can help you.

[PLEASEHELPASAP]

You helped me the other times too, I just went through my feed. I want to delete the row if Column AD does not have the letter A or B in it.