View Single Post
Old 09-09-2019, 07:52 AM
Logit Logit is offline Windows 10 Office 2007
Join Date: Jan 2017
Posts: 274
Logit is on a distinguished road

See if this edit does it :

Sub Multi_FindReplace()
'PURPOSE: Find & Replace a list of text/values throughout entire workbook

Dim sht As Worksheet
Dim fndList As Variant
Dim rplcList As String
Dim x As Long

fndList = Array("$", "%", "&")  '<-- list individual characters here
rplcList = "_"

'Loop through each item in Array lists
  For x = LBound(fndList) To UBound(fndList)
    'Loop through each worksheet in ActiveWorkbook
      For Each sht In ActiveWorkbook.Worksheets
        sht.Range("A2:A25").Replace What:=fndList(x), Replacement:=rplcList, _
          LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, _
          SearchFormat:=False, ReplaceFormat:=False
      Next sht
  Next x

End Sub
Reply With Quote