Sub fen()
Dim i As Integer
Dim arr, s, isum
Dim h As Integer
arr = Range("a1:i11")
isum = Selection
Do While 1
For i = 1 To 11
h = Int((9 - 2 + 1) * Rnd + 2)
arr(i, 1) = arr(i, h)
s = s + arr(i, 1)
Next
If s = isum Then
Exit Do
Else
s = 0
End If
Loop
Range("a1:a11").ClearContents
Range("a1:a11") = Application.Index(arr, , 1)
End Sub