VBA: Getting a random number
Posted on 2013-05-25
I am trying to get a random number with 4 significant figures using this formula
num = Round(Rnd(), 4) * 10 ^ Int((Rnd * 10) - 5)
Although the components work out nicely the final result comes up with lesser significant figures. How can I get only 4 significant figures in VBA?