To add a short Variant (using a Variant <g>) to the pile:

Code:
Sub GetDoubles(S As String, D() As Double)
Dim n As Long, V
  For Each V In Split(S, " ")
    If Len(V) Then ReDim Preserve D(n): D(n) = V: n = n + 1
  Next
End Sub
Olaf