D
dallas
Sub randomize()
Range("H2") = Int((Range("B4") - Range("B3") + 1) * Rnd + Range("B3")
End Sub
I want to randomize from more than "B4 - B3".
"B4 - B3" and "C4 - C3" and "D4 - D3" and "E4 - E3"
and get the rnd result in "H2
Range("H2") = Int((Range("B4") - Range("B3") + 1) * Rnd + Range("B3")
End Sub
I want to randomize from more than "B4 - B3".
"B4 - B3" and "C4 - C3" and "D4 - D3" and "E4 - E3"
and get the rnd result in "H2