Does RandBetween in microsoft word exist?

Question

That's pretty much the question. I'm trying to get a code that chooses a random number between -1 and 1. 

Answer 1

There is no such function built in, but you can easily create on yourself:

Function RandBetween(Bottom As Long, Top As Long) As Long
    RandBetween = Bottom + Int(Rnd * (Top - Bottom + 1))
End Function

and use it like the Excel function.

---

Regards, Hans Vogelaar

Answer 2

i used one from here: http://msdn.microsoft.com/en-us/library/f7s023d2(v=vs.90).aspx

unfortunately, it does nothing for my code.

Answer 3

Try:

Randomize Timer
h = CLng(Int((3 * Rnd()) - 1))

Note that you may get an error if i=1 and h = -1.

---

Cheers
Paul Edstein
[MS MVP - Word]

Answer 4

Try:

Randomize Timer
h = CLng(Int((3 * Rnd()) - 1))

Note that you may get an error if i=1 and h = -1.

---

Cheers
Paul Edstein
[MS MVP - Word]

that's amazing, how did you know? it worked very well, perfectly and I've been trying for so long too. where's the negative value? so so amazing, thank you so much.

Answer 5

Hi tonayie,

3 * Rnd() produces a number between 0 and 3.
Int(3 * Rnd())  discards the decimal parts and thus returns 0, 1 or 2
Deducting 1 from 0, 1 or 2 returns -1, 0 or 1.

Quite simple, really.

---

Cheers
Paul Edstein
[MS MVP - Word]