I am working with a database of clients where we append client names multiple times. What would the VBA code look like to find all of the records containing a particular name and change that name to a new name. This would be like a find and replace in Excel.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
IndianaBeancounter
0
Discussion
Hi, please use descriptive titles for the question and have you thought about just using a Find/Replace for the entire workbook? That's really going to be the fastest way to do it.
don (rep: 1989) May 23, '20 at 4:43 pm