![]() ![]() VBA code: Find and replace multiple values at once Sub MultiFindNReplace()ĭim InputRng As Range, ReplaceRng As Range Click Insert > Module, and paste the following code in the Module window. Then hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.ģ. Please create your conditions that you want to use which contain the original values and new values. If you are tired of find and replace the values time and time again, the following VBA code can help you to replace multiple values with your needed texts at once.ġ. For example, I have a range of data, and now I want to replace all Apples to Red Apples, Oranges to Green Oranges, Bananas to Yellow Bananas and so on as following screenshots shown, do you have any good ideas to solve this task in Excel?įind and replace multiple values at once with VBA code But sometimes, you need to apply many-to-many replacement simultaneously. As we all known, we can use Find and Replace function to find multiple same cell and replace them with a value as you need.
0 Comments
Leave a Reply. |