Pick a random number

[Oeysbrei]

Hi,

I need a formula that pick`s a random number from 1 - 34 and place it in A1 to G1.
If the number in A1 will be 1, this number has been taken, and can not be used in the other cells.

This is the first step, so I dont have any workbook to share yet.

Hope that somebody can help me solv this.

Best regards

Øystein

[YasserKhalil]

In a module put this UDF

Please Login or Register  to view this content.

Usage:
In A1:

Please Login or Register  to view this content.

and drage to G1

[YasserKhalil]

This is also another solution (MarcL's ideas)

Please Login or Register  to view this content.

[Oeysbrei]

Thanks for the reply, but is there a way I can ad this code to a comandbutton?

regards
Øystein

[YasserKhalil]

Do you mean commanbutton on worksheet or userform?
Either you can assign the macro to any button or shape.

[Oeysbrei]

In a module put this UDF

Please Login or Register  to view this content.

Usage:
In A1:

Please Login or Register  to view this content.

and drage to G1

Hi again,

This only returns the value 1 in all of the cells.
I need the numbers to vary between 1 - 34, and different everytime I do the rutine. I also want it to work from a comandbutton.

Thanks for youre quick response and help so far

Best regards
Øystein

[jindon]

Try
Adjust s for starting number and e for ending number

Please Login or Register  to view this content.

[YasserKhalil]

You can test the other solution. And also the UDF is working fine for me

[Oeysbrei]

Do you mean commanbutton on worksheet or userform?
Either you can assign the macro to any button or shape.

Commandbutton on worksheet

[YasserKhalil]

In worksheet module

Please Login or Register  to view this content.

[Oeysbrei]

In worksheet module

Please Login or Register  to view this content.

Thank yoy so mutch,

This worked perfect

Best regards
Øystein

[YasserKhalil]

You're welcome. Glad I can offer some help.