Clear cell if Area code if found

[martinez_pedro]

Hi i need some help with this code the code, the code works good for a single search but i would like to add to search for more than one area code
these is all the area code i need to add 210 214 254 281 361 409 469 512 682 713 806 817 830 832 903 915 936 940 956 972 979
and also to change instead of column a it needs to be column d,e,f,g
Any help with this i would really appreciated
Thanks

Please Login or Register  to view this content.

[patel45]

attach please a sample with comments

[vipul.halbe]

It does not seem that difficult.
U could attach a sample file?

[martinez_pedro]

Here you go I attach the sample list

[patel45]

attach please a sample with comments

I don't see any comment, any macro, I don't understand what you want

from forum rules

Want to get your question answered quickly?

Ensure your question is not too vague. Don't assume anyone is familiar with your problem. While you can upload small attachments, describe your problem in the body of the post. We are fortunate to have several Excel gurus, but few mind-readers.
On the other hand, skip irrelevant details. Be descriptive and concise. Short, direct, and to-the-point questions with apt thread titles are almost always answered promptly.
Keep the scope reasonably narrow. Questions like, "How do I set up an accounting system in Excel?" might be a long time waiting.
Explain what you've already tried. ("Calculation is set to automatic, but formulas still don't compute") so helpers don't waste your time or theirs.
Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
If your question has not been answered within a day, consider adding another post with any additional information you believe is relevant. If you think your post is good as is, just reply to your own thread with the words "Bump no response", which will bring it to the top of the forum.

[martinez_pedro]

Question one: Can this be change to to range D,E,F,G.

Please Login or Register  to view this content.

Question two : Can you change the macro to search all these area codes
210, 214, 254, 281, 361, 409, 469, 512, 682, 713, 806, 817, 830, 832, 903, 915, 936, 940, 956, 972, 979

Please Login or Register  to view this content.

The results Will be that all the phone numbers that match the area code the macro will clear the contents of the cell

Thanks again I hope this makes it easier to understand.
Also I attach a smaller workbook with comments and the macro

[patel45]

try this

Please Login or Register  to view this content.

[shg]

Another way:

Please Login or Register  to view this content.

[martinez_pedro]

Thank you very much the macro accomplish what i was trying to do
I appreciated guys