Set Arr = CreateObject("Scripting.Dictionary") BgnRow = 2 EndRow = .Cells(Rows.Count, "A").End(xlUp).Row For i = BgnRow To EndRow If .Cells(i, "D").Value = "V" Then Arr(i) = .Cells(i, "A").Value End If Next i
Set Arr = CreateObject("Scripting.Dictionary") BgnRow = 2 EndRow = .Cells(Rows.Count, "A").End(xlUp).Row For i = BgnRow To EndRow If .Cells(i, "D").Value = "V" Then Arr(i) = .Cells(i, "A").Value End If Next i