View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul LaPlant Paul LaPlant is offline
external usenet poster
 
Posts: 4
Default Rnd (Random) in VBA

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!