AW: Suchen/Ersetzen: Anzahl Ersetzungen
08.04.2005 21:37:02
Ramses
Hallo
mal als Beispiel
Option Explicit
Sub Replace_Mass()
Dim myC As Range, repCounter As Integer
Dim toFind As String, toRepl As String, sAddress As String
repCounter = 0
toFind = "Muster"
toRepl = "Mann"
For Each myC In ActiveSheet.UsedRange
Set myC = Cells.Find(What:=toFind, _
LookAt:=xlPart, LookIn:=xlFormulas)
If Not myC Is Nothing Then
myC.Replace What:=toFind, Replacement:=toRepl, LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Set myC = Cells.FindNext(after:=ActiveCell)
repCounter = repCounter + 1
End If
Next myC
If repCounter > 0 Then
MsgBox repCounter & " Ersetzungen vorgenommen"
Else
MsgBox "Suchbegriff nicht gefunden"
End If
End Sub
Gruss Rainer