Not really sure what you are trying to achieve or why but maybe this will help
Sub Test_2()
Dim StringA As String
Dim FinalStringA As String
Dim vArray
vArray = Array("There is 1 line of text here", "There are 2 lines of text here")
Dim vArrayFind
vArrayFind = Array(" 1 ", " 2 ")
Dim vArrayReplace
vArrayReplace = Array(" ONE ", " TWO ")
Dim i As Long
For i = LBound(vArray) To UBound(vArray)
'There is ONE line of text here
StringA = vArray(i)
FinalStringA = Replace(StringA, vArrayFind(i), vArrayReplace(i))
MsgBox FinalStringA
Next 'i
End Sub
Bookmarks