September 11th, 2005, 07:28 AM
|
|
Hellom from Steved
I had False change it to true and now recalculating.
{=UniqRandInt(40, False)} now {=UniqRandInt(40, True)}
Thankyou.
"Steved" wrote:
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
|