Private Sub Worksheet_Activate() Dim d, arr, brr(), s$, i, j, m Set d = CreateObject("Scripting.Dictionary") arr = Sheet2.[A1].CurrentRegion ReDim brr(1 To UBound(arr), 1 To 8) For i = 2 To UBound(arr)