Excel VBA Macro: Find and Replace Values in a Range (Step-by-Step Tutorial)

Описание: Excel VBA Macro: Find and Replace Values in a Range (Step-by-Step Tutorial). 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:
https://gsociology.icaap.org/datauplo...

#ExcelVBA #ExcelMacro