Skip number in sequence

[ldoodle]

Hey,

I'm doing this:

Rand = WorksheetFunction.Choose(WorksheetFunction.RandBetween(1, count), 5, 10, 15, 20, 25, 35, 40, 45, 50, 55, 60)

The values for CHOOSE are hard coded at the moment, but I need them to be dynamic. The count parameter for RandBetween is a cell value. This could change, and then in turn the number of values for CHOOSE.

If the start number is, in this case, 5, how would I get the next values to be mulpitples of 5? The start number can be anything, and is based on a rounded division of a total value and a count value.

So:

if the total is 68 and count is 11 the result is 6.18, rounded to 6. So there should be 11 multiples of 6 for the values for CHOOSE.

If the total is 70 and the count is 10, the result is 7. So there should be 10 mulitples of 7 for the values for CHOOSE.

Building the string of values I can do. But using that string (comma separated) in CHOOSE doesn't work.

Is that possible? To pass a dynamic number of arguments to CHOOSE?

Thanks!