Posted to microsoft.public.excel.programming

external usenet poster

Posts: 1

randomize

Sub randomize()
Range("H2") = Int((Range("B4") - Range("B3") + 1) * Rnd + Range("B3")

End Sub

I want to randomize from more than "B4 - B3".

"B4 - B3" and "C4 - C3" and "D4 - D3" and "E4 - E3"

and get the rnd result in "H2

--
Message posted from http://www.ExcelForum.com

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
randomize a list	LelandKramer	Excel Discussion (Misc queries)	1	July 13th 09 09:29 PM
how can I randomize a set of 496 numbers?	Stuart Leeman	Excel Discussion (Misc queries)	3	May 7th 09 07:08 PM
randomize data	rmg2828	Excel Discussion (Misc queries)	1	July 17th 06 05:01 PM
How do I randomize words within a row?	K8	Excel Discussion (Misc queries)	2	May 25th 05 09:22 PM
Randomize a list	Kevin G	Excel Programming	3	July 22nd 03 03:40 PM

All times are GMT +1. The time now is 03:46 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us