AW: Zellenbereich kopieren und Zeichen ergänzen
20.05.2015 17:32:07
Uwe
Hallo Alex,
Sub BereichKopieren()
Dim oWsQ As Worksheet, oWsZ As Worksheet
Dim varC As Variant, i As Long, j As Long, strI As String
Set oWsQ = ActiveSheet
Set oWsZ = Worksheets("Tabelle3")
strI = oWsQ.Index & "_"
varC = oWsQ.Range("A9:H9").Value
For i = 1 To UBound(varC, 1)
For j = 1 To UBound(varC, 2)
varC(i, j) = strI & varC(i, j)
Next j
Next i
oWsZ.Range("A35").Resize(i - 1, j - 1).Value = varC
Application.Goto oWsZ.Range("A35"), True
MsgBox "Übertrag mit Index fertig."
For i = 1 To UBound(varC, 1)
For j = 1 To UBound(varC, 2)
varC(i, j) = Mid(varC(i, j), InStr(1, varC(i, j), "_") + 1)
Next j
Next i
oWsZ.Range("A35").Resize(UBound(varC, 1), UBound(varC, 2)).Value = varC
MsgBox "Index wieder weg"
End Sub
Gruß Uwe