I found the RANDBETWEEN function ...
..., but it does not seem to work in VBA. I am very new to
VBA and any suggestions would be welcome.

Hi. Just to add.
On the vba issue, go to the vba editor.
On the menu, do Tools | References...
and select "atpvbaen.xls"
(name means: Analysis Tool Pak, VBA, US)

Now, the following code should work:

Dim n
n = RANDBETWEEN(1, 10)

HTH :)
--
Dana DeLouis
Win XP & Office 2003


"GSpline" wrote in message
...
How would I go about calculating random numbers using a low and high
number
boundary? I found the RANDBETWEEN function and this is apparently exactly
what I am looking for, but it does not seem to work in VBA. I am very new
to
VBA and any suggestions would be welcome.