12.12.2022, 13:18
Nun in der hochgeladene Datei:
Code:
Sub M_snb()
With Tabelle1.Rows(6)
With .Find("Geburt-Datum").Offset(1).Resize(Rows.Count - 7)
For j = 0 To 2
.Replace Array("vor", "nach", "um")(j), Array("BEF", "AFT", "ABT")(j)
Next
sn = .SpecialCells(2)
For j = 1 To UBound(sn)
If InStr(sn(j, 1), ".") Then sn(j, 1) = Mid(Format(Format(Replace(sn(j, 1), ".", "/"), "d MMM yyyy"), ">"), 1 - 2 * (Len(sn(j, 1)) = 7))
Next
End With
.Find("Geburt.-.Datum").Offset(1).Resize(UBound(sn)) = sn
End With
End Sub