My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 Random Number
|
|
 Nov 28 2006, 10:22 AM
Post
#1
|
|
|
UtterAccess Enthusiast Posts: 74  |
Hiya
I';ve created a Random Number thingie =Rand()*20 Formatted the result to zero decimal places no prob. The problem is when i do things to the spreadsheet the numbers change. How do I stop this happening pls ? Cheers |
 |
 
|
|
Nov 28 2006, 10:31 AM
Post
#2
|
|
|
UA Forum + Wiki Administrator Posts: 11,947 From: Sudbury, Ontario, Canada |
Your formulat will recalculate whenever the worksheet recalcuates. To preserve the list of random numbers, copy the list and then do a paste/special Values to replace the formula with the values it has generated.
Glenn |
|
|
|
|
Nov 28 2006, 11:05 AM
Post
#3
|
|
|
Retired Moderator Posts: 10,959 From: Prague,CZ / Kiev,UA |
Hello,
there's one more possibility... write an UDF, e.g.: CODE [color="blue"]Function[/color] [color="blue"]Random[/color](Lower [color="blue"]As[/color] [color="blue"]Long[/color], Upper [color="blue"]As[/color] [color="blue"]Long[/color]) [color="blue"]Random[/color] = Lower + Int(Rnd() * (Upper - Lower + 1)) [color="blue"]End[/color] [color="blue"]Function[/color] and use like =RANDOM(1,10) in your worksheet. It will recalculate only if you force full recalculation, by pressing Ctrl+Alt+F9 Martin |
|
|
|
|
Nov 28 2006, 11:21 AM
Post
#4
|
|
|
UA Forum + Wiki Administrator Posts: 11,947 From: Sudbury, Ontario, Canada |
That is a nice variation, Martin. I didn't realize that UDFs don't auto recalculatate.
Glenn |
|
|
|
|
Nov 28 2006, 11:47 AM
Post
#5
|
|
|
Retired Moderator Posts: 10,959 From: Prague,CZ / Kiev,UA |
No they don't... unless you use ranges as parameters (IMG:http://www.utteraccess.com/forum/style_emoticons/default/sad.gif)
Martin |
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 20th May 2013 - 04:13 AM |