Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
EXCEL MACRO - EXCEL VBA HOW TO USE THE FIND AND REPLACE FUNCTION
OK Skip thanks for the code .. but to get all the names and address for all the contact it will be a lot time ... What I need to do is to seach for each text located in A6, A7,A8 Then Look for that text in the entire sheet and replaced to UNK. I need to run these macro in 3,000 files so it...- FERRiver
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
EXCEL MACRO - EXCEL VBA HOW TO USE THE FIND AND REPLACE FUNCTION
Hello Gavin, Thank you for you help... Here is the macro .. as you can see is replacing the customer info to UNK (A6+A7+A8) in the entire file.. I created the macro by using the find and replace function .. it is able to replace the multiple customer info to "UNK" - How can I change this macro...- FERRiver
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
EXCEL MACRO - EXCEL VBA HOW TO USE THE FIND AND REPLACE FUNCTION
Hello Everyone!!! I need some help ... please ... I work for a call center - I have a request to review 30,000 contacts .. and send over to other businesss .. so I have to replace the customer address to something like "UNK" for each contact So if i know the customer information is in C7 how...- FERRiver
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
