Random numbers of a dice

[Robins]

I'm working on a procedure which gives me random numbers of a dice. The code is working but I want to add some stuff, but I don't know how.

Please Login or Register  to view this content.

The idea is that the user can choose how many random numbers he wants to use. In this example it is 10000 numbers. I came up with this but it isn't working:

Please Login or Register  to view this content.

How knows how to solve this?? Thanks!!

[teylyn]

try

Please Login or Register  to view this content.

You want to concatenate the value of your variable X with the partially complete text representing the cell range. So, using a text string for the cell range, you need the concatenation operator to concatenate your variable value.

hth

[davesexcel]

Please Login or Register  to view this content.

[Robins]

It is working although I've got another problem. The sum isn't working:

Range("C1").Formula = "=sum("a1:a" & x)"

[Richard Buttrey]

Hi,

Please Login or Register  to view this content.

HTH