Sub teilstring()
Dim raZelle As Range
Dim strAdresse As String
With Columns("B")
Set raZelle = .Find("K*", lookat:=xlPart, LookIn:=xlValues)
If Not raZelle Is Nothing Then
strAdresse = raZelle.Address
Do
Cells(raZelle.Row, 2) = "K"
Set raZelle = .FindNext(raZelle)
Loop While Not raZelle Is Nothing And raZelle.Address <> strAdresse
End If
End With
End Sub
Sub teilstring2()
Dim loZeile As Long
With Columns("B")
For loZeile = 1 To IIf(IsEmpty(Cells(Rows.Count, 2)), Cells(Rows.Count, 2).End(xlUp).Row, Rows.Count)
If Left(Cells(loZeile, 2), 1) = "K" Or Left(Cells(loZeile, 2), 1) = "V" Then Cells(loZeile, 2) = Left(Cells(loZeile, 2), 1)
Next loZeile
End With
End Sub
Excel Arbeitsblatt zeitgesteuert löschen
micico 04.03.2007 - 89 Hits - 8 Antworten
[Excel] Formeln mit VBA nutzen
Björn 07.10.2007 - 206 Hits - 2 Antworten
mehre Excel Arbeitsblaetter in PowerPoint via VBA ansprechen
sammille 12.03.2008 - 100 Hits -
Schnellreferenz Excel VBA
Joshuan 23.05.2008 - 219 Hits - 3 Antworten
VBA-Excel
mentosbasi 28.05.2008 - 350 Hits - 3 Antworten