Witam.
Nie działa mi ta funkcja, która powinna zastąpić w aktywnym Worksheecie w kolumnach AB:AH kropkę na nic "", itp. Występuje błąd mismatch.
Sub Multi_FindReplace() 'PURPOSE: Find & Replace a list of text/values throughout entire workbook 'SOURCE: www.TheSpreadsheetGuru.com/the-code-vault Dim sht As Worksheet Dim fndList As Variant Dim rplcList As Variant Dim x As Long fndList = Array(".", ",", "-", "CR", "DR") rplcList = Array("", ".", "", "H", "S") 'Loop through each item in Array lists For x = LBound(fndList) To UBound(fndList) 'Loop through each worksheet in ActiveWorkbook in colums "AB:AH" For Each sht In ActiveWorkbook.Worksheets("sheet1").Columns("AB:AH") sht.Cells.Replace What:=fndList(x), Replacement:=rplcList(x), _ LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, _ SearchFormat:=False, ReplaceFormat:=False Next sht Next x End Sub
Z góry dziękuję za pomoc.
Anna L.