Replace value cell with another value in VBA

Question

Hello, i need few help in an excel function that i used to replace text in a cell with another one and this is the function it work perfect and this is the function :

rngTargetD.Replace _

 What:="HELLO", Replacement:="HI", _

 SearchOrder:=xlByColumns, MatchCase:=True

My questions is , how can i change this function if in case the value that i want to change is an array ?

Thank you so much

Moved from: Office / Excel / Windows 10 / Office 2013

Answer 1

Hi Hassan,

Select the range of cell and then run this macro:

Sub ReplaceSelection() <br><br>    <br><br> Selection.Replace _ <br><br> What:="HELLO", Replacement:="HI", _ <br><br> SearchOrder:=xlByColumns, MatchCase:=True <br><br>  <br><br>End Sub

It's applied to all selected cell.

Hope that helps.