Hi. No advantage really. I like your "Index" version myself.
A one Transpose version could be something like this:

v = [Transpose(SMALL(A1:A10,ROW(1:3)))]

No advantage of course. :) Just sharing an idea.

--
Dana DeLouis
Using Windows XP & Office XP
= = = = = = = = = = = = = = = = =


"Harlan Grove" wrote in message
...
"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?