Zeilen löschen
30.06.2003 11:25:48
Ernst
Dim l As Long
Dim Zl As Long
Sheets("Tabelle1").Activate
Zl = ActiveSheet.UsedRange.Rows.Count
Range("A1").Activate
For l = 1 To Zl
If InStr(1, ActiveCell.Value, "Tel.:") Then ActiveCell.EntireRow.Delete
ActiveCell.Offset(1, 0).Select
Next l