Excel VBA Macro: Find and Replace Values (Dynamic Range)

Показать описание

Excel VBA Macro: Find and Replace Values (Dynamic Range). In this video, we create a macro with Excel VBA that finds a replaces any value in a range of data. We start off by writing code that determines the length of a set of data, then looks for a particular value in one column and replaces all instances of that value with another value. We then use the same find and replace function across multiple columns. Finally, we show that the replace function is case sensitive and can handle one or multiple characters in a string.

Data used in this video:

#ExcelVBA #ExcelMacro

Рекомендации по теме

Комментарии

Hi I wanted to get the countA of any column with visible rows data and wanted to exclude the hidden rows

manojgaidhankar

Hi Gregg. Thanks for the help. I tried your code with a wildcard and if did not seem to work. Did i miss something?

Set X = Range(Cells(3, 2), Cells(endrow, 2))
For Each Y In X.Cells
Y = Replace(Y, "*MAT*", "TUN")
Next Y

DouglasSubbs

How do I do it if I want to replace multiple values but with different words

annymedina

Can i put Y = Replace(Y, "<>S", "$") ? Basically try to change everything else but not the letter S. New to VBA thus im not sure how to go about this with my different set of data.

Batriderrenz

What happens if your column (A) has blank fields (Parent and Child SKU's for example?). When I ran this it replaced the values in the correct column C, but also in a column I didn't want included (Column B). How to prevent that? Also, how to get it to only find the exact value, so if I have d1 as a value it just finds that and replaces it but not if it's contained in another column with that value, ie, 001d100. Thanks

philipwall

how to do find & replace for multiple excel with multiple value?

SanjayGururao

What I should do if I have over 30 000 records and error: "Method 'End' of object 'Range' failed"?

dragonofie

How do I replace blank cells with "something". Actually Y = Replace(Y, "", "Something") this is not working

rakeshshamantula

Excel VBA Macro: Find and Replace Values (Dynamic Range)

Excel VBA FIND Function (& how to handle if value NOT found)

Find and Replace Multiple Values in Excel using VBA Macro

Advanced Find, Replace or Update in VBA & Macros for Excel

Excel VBA - Find And Replace

Excel VBA Find Function - In-Depth Tutorial with Examples

How to get the Last Row in VBA(The Right Way!)

Excel Macro VBA Tip 17 - Find Last Row and Last Column with VBA

Compare Two Worksheets Excel VBA Macro

Welcome on Master of Excel! 😊

Excel VBA Basics #8 - Find the LAST ROW or COLUMN dynamically and clearing out your last report

Excel VBA: Copy Data from one Sheet to Another (Absolute Vs. Relative Macro Recording)

Find and replace multiple values at once in Excel using VBA

VBA Macro to Copy Data from Another Workbook in Excel

Excel VBA - Write a Simple Macro

Next Empty Row Trick in Excel VBA & Macros

Excel Macro and VBA Extract the filename of a file in a Folder

Excel VBA IF THEN Statement (with ELSEIF & Looping in cells)

Excel VBA Cell Value - Code Included

#Excel VBA to Select the Next Empty Cell or Row - Macros

Learn Excel VBA to Automate Anything

Add Buttons To Selection Excel VBA Macro

The Ultimate Guide to Copying Data using Excel VBA

Excel Macros & VBA - Tutorial for Beginners

Excel VBA Macro: Replace Blank Cells with Text, Numbers (Zeros), and Formulas