For Statement in assigning random values to integers in VBA

Question

NN1 = Int((500 - 100 + 1) * Rnd + 100)
NN2 = Int((500 - 100 + 1) * Rnd + 100)
NN3 = Int((500 - 100 + 1) * Rnd + 100)
NN4 = Int((500 - 100 + 1) * Rnd + 100)

I assume that we can reduce this into

For i = 1 to 4
"NN" & i = Int((500 - 100 + 1) * Rnd + 100)
Next i

However, I am getting a compilation error. How do I rectify this?

Use a Dictionary or Collection. "NN" & i is not equivalent to a variable. — BigBen
– BigBen, Commented Apr 21, 2020 at 4:08

Kusa Shaha · Accepted Answer · 2020-04-24 05:06:10Z

1

Dim NN() As Integer
For i = 1 To 4
NN(i) = Int((500 - 100 + 1) * Rnd + 100)
Next i

I would suggest using an Array instead of multiple Integers

answered Apr 24, 2020 at 5:06

Kusa Shaha

1101 gold badge4 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

For Statement in assigning random values to integers in VBA

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related