Home |
Search |
Today's Posts |
#12
|
|||
|
|||
Thanks very much Dave
Yes I carried out what you described and yes it created Random Numbers. I still have a Issue and that is when pushing F9 it will not recalculate. And to Bernd if you get to read this yes I get a double on the same line Line 1 No 7, Line 4 No 35, Line 6 No 12, Line 8 No 40, and line 10 12 As pasted below. 26 40 17 12 7 7 29 22 24 12 13 31 1 31 33 29 2 17 35 32 15 39 35 3 38 15 21 31 3 24 19 12 25 26 11 12 34 33 24 40 37 10 28 40 10 22 5 40 28 1 24 5 5 32 12 2 12 16 13 38 Thanks once again Dave. "Dave Peterson" wrote: It sounds like you pasted it under the ThisWorkbook module. Once you get to the VBE (alt-f11 is nice) hit ctrl-r (to see the project explorer) find your project rightclick on it Insert|Module Paste it there. (look under the ThisWorkbook module and delete it from there if I guessed right.) Then back to excel and recalculate. Steved wrote: Yes top left corner right clicked on excel icon opened it and pasted it. "Dave Peterson" wrote: Did you put it in a general module? Steved wrote: Hello Bernd from Steved I've put your UDF in VBA and Copied =UniqRandInt(40, false) ok it has #NAME? What have I not done right please I presume F9 to execute Thankyou. "Bernd Plumhoff" wrote: Hello, I suggest to insert a VBA module with my UDF function UniqRandInt() (see www.sulprobil.com), then select cells A1:F1 enter =UniqRandInt(40, false) as array formula (CTRL+SHIFT+ENTER) and copy this down to A10:F10. I admire elegant worksheet function solutions, but if you like to have a general and robust solution, a thoroughly tested UDF function might be the answer of your choice (don't trust my function, test it!). HTH, Bernd -- Dave Peterson -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
random numbers, how can you utilize it without repeating them | Excel Discussion (Misc queries) | |||
random numbers from a data of numbers? | Excel Worksheet Functions | |||
Validating random numbers | Excel Worksheet Functions | |||
Random Numbers Change? | Excel Worksheet Functions |