Sub test()
Dim arr(), i As Integer
arr = Range("b1:b" & Cells(Rows.Count, 2).End(xlUp).Row).Value
For i = 1 To UBound(arr)
Shell "explorer " & arr(i, 1)
Next
End Sub
Sub test()
Dim arr(), i As Integer
arr = Range("b1:b" & Cells(Rows.Count, 2).End(xlUp).Row).Value
For i = 1 To UBound(arr)
Shell "explorer " & arr(i, 1)
Next
End Sub