Re: Rnd (Random) in VBA

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Paul LaPlant (pepeexcel_at_hotmail.com)
Date: 04/14/04

Date: Tue, 13 Apr 2004 18:12:26 -0700

Thanks for the quick replies. Tom, yours did the trick. The only thing
I changed was to adjust
lngNum = Rnd() * 6 + 1
to
lngNum = Rnd() * 5 + 1.

This gives me my random between 1 and 6. The first method gave me up to
7.

This was great. As usual, you are a big help.

Paul

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

Re: ExcelTip/ExcelForum threading
... I see the same thing as Tom. ... They appear to be replies to their own ... > own forum software, so I don't know that he has control of that aspect. ... > keepITcool ...
(microsoft.public.excel.programming)
Re: How do I...
... > simple question about details to design a rocket. ... > The majority of you gave me bad and stupid replies. ... > You seem like a very lame group with the exception of a few members. ... > Tom the Canuck. ...
(rec.models.rockets)
Re: Creating a list of directories
... I intended no slight, but, rather, was inviting you to look at Tom and Robs ... "mousetrap" wrote in message ... >> If you were unhappy with their replies, a recent thread contains offerings>> from John Green and Dave Peterson: ...
(microsoft.public.excel.programming)
Re: Is Yads an artificial intelligence ?
... artificial intelligence programs which aims to trick the reader into ... thinking that the computer sending the replies is human by selecting key ...
(rec.arts.drwho)
SUMMARY: libcda.so library
... I got 3 replies very fast many thanks. ... Iam enclosing the replies from ... Tom and ... If you went and got a copy of libcda.so (and ALL related libraries) ...
(Tru64-UNIX-Managers)