VBA - How to delete rows whose cells contain

[TopLearner]

Hello everybody,

I hope you are well.

I have the column A with multiple cities.
A1 is the header "Location"

Then, I have the name of cities in the range A1:A200.

I also have the column B with the header "Revenue"


I would like to create a macro that delete those rows that contains "(Central)" in the "Location" column, column "A"


My attempt is

Sub LimpiarFilas()

Dim ws As Worksheet
Dim cell As Range

Set ws = Sheet1


For Each cell In Range("A:A")

If cell.Value = "(Central)" Then
cell.EntireRow.Delete

End If

Next cell

End Sub

However, it is not working as cells in column A contain either cities' names like Milan or cities' names + (Central). For instance Cordoba (Central).
Then, I would like to delete the row that contains Cordoba (Central)
Would it be something like the below?

IF cell.value = IF(Isnumber(match("(Central)",B1)),"Yes","No").Value = "Yes" Then
cell.entirerow.delete

Thanks
Sanchez

 

[Joe4]

You are welcome.
Glad we were able to help!