AW: große anzahl Spalten Summe bilden
17.03.2017 08:01:55
Markus
PS bis jetzt habe ich das hier, aber es funkt nicht so richtig.
Sub test2()
Dim dic
Dim arr
Dim ID As String
Dim Z As Long
Dim f As String
Dim i As Integer
Dim lzber As Integer
lzber = Sheets("Ber").Cells(Rows.Count, 1).End(xlUp).Row
With Sheets("ber")
arr = .Range("G2:O10").Value
' " & lzber).Value
End With
Set dic = CreateObject("Scripting.Dictionary")
With Sheets("BER")
For Z = 1 To UBound(arr, 1)
ID = Join(Array(arr(Z, 1), arr(Z, 2), arr(Z, 3), arr(Z, 4), arr(Z, 5), arr(Z, 6), arr(Z, 7) _
, arr(Z, 8), arr(Z, 9)), "|")
dic(ID) = dic(ID) + 1
arr(Z, 1) = dic(ID)
MsgBox "Summe: " & WorksheetFunction.Sum(ID)
Next
End With
End Sub