Posted to microsoft.public.excel.programming

external usenet poster

Posts: 44

how to choose random namber form loop?

hello,

i have simple loop

For i = 1 to 100
call something
Next i

and i'd like to run this loop on 20 random "i" numbers without repetition
eg: 74, 3, 32, 1, 2, 15, 92, 22, and so on...

how can it be worked out?

rgs

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I choose more than one item from list in a form in Excel?	Jolly	Excel Worksheet Functions	7	July 14th 08 06:28 PM
Excel range choose button in VBA form	Philipp	Excel Programming	5	December 15th 05 04:47 PM
loop through form objects	Steven K	Excel Programming	1	August 23rd 04 07:47 PM
loop random number	mrmark	Excel Programming	4	June 22nd 04 03:14 PM
random number generation: loop	NickC[_2_]	Excel Programming	2	January 23rd 04 07:37 AM

All times are GMT +1. The time now is 11:33 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us