How to Replace All occurrences in Array?

[Fractalis]

Hi all,

Having a one dimensional VBA array, is possible to find a list of strings and Replace All occurrences of each string within array?

 

[Peter_SSs]

Peter, can you modify your VBA cod to get results in F2:Fx?

You would simply add this just before the End Sub

Range("F2").Resize(UBound(vSource)).Value = Application.Transpose(vSource)

 

[Tom.Jones]

You would simply add this just before the End Sub

Range("F2").Resize(UBound(vSource)).Value = Application.Transpose(vSource)

Thank you Peter.