Looping through a list of city names

[jm594]

I have a list of city names running across the top of my spreadsheet starting with column B1.

Miami Dayton Detroit Milwaukee Houston Boston Phoenix St. Petersburg Pittsburgh Indianapolis Taos

I want to create a macro that finds *only certain cities* and deletes the five cells underneath that city name.
In English, it would be something like this.

Loop through this list (Detroit, Boston, Pittsburgh)
Delete the five cells under Detroit
Delete the five cells under Boston
Delete the five cells under Pittsburgh
End Loop

How would I do something like this? Thank you.

[alansidman]

Some Air code for you to test:

Please Login or Register  to view this content.

[jm594]

It threw an error on the line beginning with "crit =" that stated:

Compile error:
Statement invalid outside Type block

Also, I don't wish to be prompted for the cities that I wish to delete. I would rather hard code a list of cities somewhere and then it deletes the cities in that list.

Many thanks.

[bakerman2]

Try this. I've put the list with cities to lookup in column T but you can put that anywhere.

Please Login or Register  to view this content.

[jm594]

Thanks Bakerman but it removed city names from column T where the list resides.

[Fluff13]

Try this mod to bakerman2's code

Please Login or Register  to view this content.

[jm594]

Thank you. Worked great. I appreciate the help.

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[Fluff13]

Thank you. Worked great. I appreciate the help.

You're welcome & thanks for the feedback