macro to set bottom and top values for randbetween
hi Tonso,
i suppose the values are in range("A1") and range("B1")
x = Evaluate("randbetween(" & [A1] & "," & [B1] & ")")
--
isabelle
Le 2012-10-03 10:22, Tonso a écrit :
I want to select a cell or a range of cells, then fill it with randbetween numbers.
The bottom and top values will vary from time to time. How can I accomplish this.
Maybe have an input box appear where the user could enter the bottom/top values, or
designate 2 cells where the user could input the values, invoke the macro, and have it refer to those 2 cells to get the bottom/top values?
Thanks!
Tonso
|