Random numbers

[abee4life]

can someone please tell me a random number macro code that allows me to put random numbers, between 0-5, that can repeat, in cells D23 to E33... I would like zero to be included.

Thanks.

 

[Greg Truby]

=RANDBETWEEN(0,5)

If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in.

 

[abee4life]

would that be used on visual basics?

also i need the answers to go between cells D23 and E33

 

[Greg Truby]

No, that would be a formula. There's no need for VBA. You have a built-in function already at your disposal.