"Dana DeLouis" wrote...
Just a slightly different way from Tom's using Excel XP.

Dim v As Variant
v = [Transpose(Transpose(SMALL(A1:A10,{1,2,3})))]
....

And the advantage of two TRANSPOSE calls vs one INDEX call is?