Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP! Custom Random NumberFunction in VBA
I need help with this code. 1.)I need a VBA fnction that will take a fix set of numbers, scramble them, and never use the same number 2 times. Its gotta be simple, but Ive never worked with random generators in VBA before. Please send help to Thanks All. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP! Custom Random NumberFunction in VBA
put your numbers in column A
-----Original Message----- I need help with this code. 1.)I need a VBA fnction that will take a fix set of numbers, scramble them, and never use the same number 2 times. Its gotta be simple, but Ive never worked with random generators in VBA in B put the value =RAND() calc the sheet and sort the table by column B since the values in B are random, the sort is random Patrick Molloy Microsoft Excel MVP before. Please send help to Thanks All. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP! Custom Random NumberFunction in VBA
If you have a spare range somewhere, then
- copy the values to the range - assign the =RAND() formula to the adjoining cells - or add a value returned by the VBA Rnd() function - sort on the random numbers - return the "sorted" numbers Kevin Beckham -----Original Message----- I need help with this code. 1.)I need a VBA fnction that will take a fix set of numbers, scramble them, and never use the same number 2 times. Its gotta be simple, but Ive never worked with random generators in VBA before. Please send help to Thanks All. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom cell format using random alphabetic characters | Setting up and Configuration of Excel | |||
custom number and random text format | Excel Discussion (Misc queries) | |||
Non-random numbers generated by excel's data analysis random gener | Excel Worksheet Functions | |||
Non-random numbers generated by excel's data analysis random gener | Excel Discussion (Misc queries) | |||
How do I find random number in list of random alpha? (Position is. | Excel Discussion (Misc queries) |