Adding random numbers to acrostic

  • Thread starter Thread starter bumi
  • Start date Start date
B

bumi

I am trying to create an acrostic with the following
elements: abstractor code, location code and 6 digit
random number.
I have the following:
Acrostic= [AbstractorCode] & [LocationCode] &
[?6 digit Random#]
 
-----Original Message-----
I am trying to create an acrostic with the following
elements: abstractor code, location code and 6 digit
random number.
I have the following:
Acrostic= [AbstractorCode] & [LocationCode] &
[?6 digit Random#]
.
Click to expand...
Hi Bumi,
your post is not clear about the question that you have. I
am assuming that you want to know how to calculate a
random number.

Use the following as an example.

Dim MyValue
MyValue = Int((1000000 * Rnd) + 100000) ' Generate
random value between 100000 and 1000000

Luck
Jonathan
 
Back
Top