Posted to microsoft.public.excel.programming

Jo[_2_]

external usenet poster

Posts: 69

Locking RAND()?

Hi everyone,

Say you have in A1, A2 two formulas with Rand() in each. Say you have
a macro that does freez A1 when it hits its target value, while A2
keeps running till it hits its target value.

My question is how to freez Rand()?

Thanks,
Jo

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how can i set up rand or rand between to give only -1 or 1?	Uesiet	Excel Worksheet Functions	8	October 27th 08 02:28 PM
=INT(0+(1-0+1)*RAND()) wtf?	Robert Blass	Excel Worksheet Functions	4	October 11th 08 05:27 AM
RAND()	Dave F	Excel Discussion (Misc queries)	4	October 24th 06 08:15 PM
locking formula in cells in without locking whole sheet	SuziQ	Excel Discussion (Misc queries)	1	July 21st 06 03:58 PM
RAND()	ScottC	Excel Discussion (Misc queries)	2	May 1st 05 12:37 PM

All times are GMT +1. The time now is 11:57 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us