If Column A contains one of several strings then change column Bs string

I am fairly new to macros in excel however I have done programming before. My biggest problem is figuring out the syntax for everything. So wondering if you guys could give me a hand.

What I need is to check to see if a cell in a column matches one of several different strings. If it does then I need to change another cell in the same row but different column to say DELETE. If it does not contain that string then I simple delete it So far I have this

Please Login or Register  to view this content.

Alternatively I could delete all of the un needed rows then go back with another macro to change all of row B to say DELETED. I still face the problem of not knowing how to format a cell change.

1) Go ahead and break the habit of using .UsedRange in your method for determining the first and/or last row of data. It is full of holes and when it does break you won't know it, you just won't know it's doing wrong things to your data.

Instead, pick the row that always has data filled in, like column A, and just evaluate that column directly.

Please Login or Register  to view this content.

2) Before you run your loop, delete all the "error" rows first to speed up the process, they're no longer there to have to be evaluate. This one line of code will delete every row that has a formula in that results in an error in column A:

Please Login or Register  to view this content.

3) Maybe this then:

Please Login or Register  to view this content.

I created a test and made two columns A and B then a filled each row going down with ItemA ItemB etc for 4 rows.

Original
A B
1 ItemA ItemA
2 ItemB ItemB
3 ItemC ItemC
4 ItemD ItemD

Result
A B
1 ItemA ItemA
2 ItemB Here
3 ItemC Here
4

Cells A4 and B4 were both blank i'm suspecting the cost begins 1 cell to late and ends 1 cell to early?

Please Login or Register  to view this content.

Most people have some sort of "titles" in row 1, if you don't it's a simple adjustment:

Please Login or Register  to view this content.

You use a space-underscore combination to break long strings.

Please Login or Register  to view this content.