kann mir wer mit dieser UD- Funktion helfen (siehe Modul)
https://www.herber.de/bbs/user/116847.xlsm
A | B | C | D | E | F | G | H | I | J | K | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
3 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
4 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
5 |
...
If T Like "[A-Z]" Or T Like "[A-Z][A-Z]" Then
K = Ketten.Worksheet.Cells(Ketten.Row, T).Text
If K "-" Then Kette2 = Kette2 & K
else
...
K ist eine zusätzliche Stringvariable, die habe ich eingeführt, weil ich den Wert aus "Ketten.Worksheet.Cells(Ketten.Row, T).Text" ja mehrfach brauche und somit den langen Ausdruck nicht wiederholen muss.
Function Kette2(Vorgabe As Range, Ketten As Range)
Dim Zelle As Range
Dim T As String
Dim K As String
Application.Volatile
For Each Zelle In Vorgabe
T = Zelle.Value
Select Case T
Case "leer"
Kette2 = Kette2 & " "
Case ""
Kette2 = Kette2 & ""
Case Else
If T Like "[A-Z]" Or T Like "[A-Z][A-Z]" Then
K = Ketten.Worksheet.Cells(Ketten.Row, T).Text
If K "-" Then Kette2 = Kette2 & K
Else
Kette2 = Kette2 & T
End If
End If
End Select
Next
End Function
Function Kette2(Vorgabe As Range, Ketten As Range)
Dim Zelle As Range
Dim T As String
Application.Volatile
For Each Zelle In Vorgabe
T = Zelle.Value
Select Case T
Case "leer"
Kette2 = Kette2 & " "
Case ""
Kette2 = Kette2 & ""
Case Else
If T Like "[A-Z]" Or T Like "[A-Z][A-Z]" Then
K = Ketten.Worksheet.Cells(Ketten.Row, T).Text
If K "-" Then Kette2 = Kette2 & K
Else
Kette2 = Kette2 & T
End If
End Select
Next
End Function
Function Kette2(Vorgabe As Range, Ketten As Range)
Dim Zelle As Range
Dim T As String
Dim K As String
'Application.Volatile
For Each Zelle In Vorgabe
T = Zelle.Value
Select Case T
Case "leer"
Kette2 = Kette2 & " "
Case ""
Kette2 = Kette2 & ""
Case Else
If T Like "[A-Z]" Or T Like "[A-Z][A-Z]" Then
K = Ketten.Worksheet.Cells(Ketten.Row, T).Text
If K "-" Then Kette2 = Kette2 & K
Else
If K "-" Then Kette2 = Kette2 & T
End If
End Select
Next
End Function
Gruß Daniel