Formulas: Problem with randoms

imported_Anonymous

Intermediate

Points

1,345

Posts

135
Sep 8th 2003
- #1
Is there any way to store a randomly generated number in a cell?
and is there a way to add to this number?
Ranger

Professional

Reactions Received

1

Points

8,231

Posts

1,462
Sep 8th 2003
- #2
Hi Anon,

Sub random()
Sheet1.Range("A4").Formula = "=RAND()"
Sheet1.Range("A4") = Sheet1.Range("A4") + 2
End Sub
This generates a random number in cell A4, then adds 2 to it.

Regards,

Bill

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login

Share

This site uses cookies. By continuing to browse this site, you are agreeing to our use of cookies. More Details Close

Your browser has JavaScript disabled. If you would like to use all features of this site, it is mandatory to enable JavaScript.