gt; "") Then
ttl = ttl + 1
Cells(ttl, 2) = nArray(inx)
nArray(inx) = ""
End If
Wend
End Sub
hope this helps.
Paul
- Original Message
> From: peace
> To: MS EXCEL AND VBA MACROS
> Sent: Tue, January 5, 2010 11:1
I have a list of 10 items and I want to select randomly (and
repeatedly) from the list.
Once I have selected an item, I want to be able to select randomly
from the other 9 items. After 10 tries i should have selected all
items once.
For the 11th try I should be able to select randomly from all 1
