Looping thru columns for value

[Quint6778]

Hello!

In range("A2:Z20"), im trying to loop thru each column for cells containing a specific name ("joe dirt")
How can i loop thru these columns, and if the column doesnt contain the name id delete it.

Ive been experimenting & keep fumbling over multiple for loops. I figured id throw it out there, since this is the land of speedy experts. help me think on the right track, thank you in advance!!!

[smpita]

A somewhat slower implementation but simple enough that it should work

Please Login or Register  to view this content.

Edit: Misread column as row

[Quint6778]

Thanks for the quick reply. Let me throw a scenario at you...

I want to delete the column, and the column is comprised of dates. so just because the name doesnt appear on monday, doesnt mean i delete the entire column because it might appear just once at the end of the month. The entire column has to be blank in order to delete it.

Update-question.
I tried using a .Find method, as if i were looking thru the column for "joe dirt", then loop to next column. (however i couldnt make it work)

[smpita]

I'm not quite clear on what you're trying to achieve. Here is a copy of one of my primary search functions, it may be helpful to you.

Use like this to return the string name of the range of all cells that loosely contain the string "joe dirt". Note, with explicit false it turn off case sensitivity and search within strings. It would match "Joe Dirty 11/16/2017" The return might look like the string "A2:Z20"

Please Login or Register  to view this content.

Use like this to return the first cell address that strictly contains the word "joe dirt". It will not match "Joe dirt". If "joe dirt" is not found, it will return the string "NotFound"

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[alansidman]

This may work, if I am understanding your issue correctly

Please Login or Register  to view this content.

[Quint6778]

This is exactly what i was looking for. Havent tested, but i'll make it work. i didnt even think of the COUNT function... thank you! and thank you smpita as well!

[alansidman]

You are welcome. Thanks for the rep.