Button to generate numbers from interval 0.0xx to 0.0yy

[teh.format]

Hello,

It's my first post so I hope it will meet rules. My question is:

I would like to generate numbers from small interval ex. 0.019 to 0.031 and add it to button, I was trying to use function randbetween but I'm getting error when trying to enter these numbers.
Ater trying this function (found on this board) I'm getting only 0

Please Login or Register  to view this content.

Anyone could help with that?

Thanks in advance!

[:) Sixthsense :)]

Try this...

=0.019+(ROW(1:1)-1)*0.012

Drag it down....

[teh.format]

Hello,

It worked but how I can manage to generate these numbers from button?

[:) Sixthsense :)]

Copy the formula only

[teh.format]

I edited my answer and I think you replied for previous version ;P

Problem was I'm using polish version of Excel that why i get #NAME? in cell after adding ROW - > WIERSZ in polish it worked but can u answer how to add that into button so number can be generated by "click" ?

[:) Sixthsense :)]

Try this...

Please Login or Register  to view this content.

[teh.format]

It is working partially :P.
1. Range is from 0.019 to 1.207 at row 100 ( range should be from 0.019 to 0.031),
2. After second click of button values doesnt change (i mean its not random really ;P).

[:) Sixthsense :)]

I am little bit confused about your requirement

[teh.format]

I am little bit confused about your requirement

Let me explain more then:
I need button that generates random number from range 0.019 to 0.031 in a specified cell for ex. A1 and it needs to update (generate new number) after click. Sorry for trouble.

[Debraj Roy]

Try this..

Please Login or Register  to view this content.

rand NUmber.xlsm

[teh.format]

It's alive! Thanks
So next question is when I want to change range I need to change values

Please Login or Register  to view this content.

right? and what about rest of function

Please Login or Register  to view this content.

? Can u add comment how it works?

[Debraj Roy]

Glad that its works..

Here is the simplify section....

Please Login or Register  to view this content.

You can use CONST or NAMERANGE, if your Top & Bottom is not fixed..

[teh.format]

Again, BIG thanks!