RANDBETWEEN Query!

[apearson]

Hi People,

I know this can be done, but I don't know how:-

I have a worksheet with =RANDBETWEEN(1,3), in a range of cells, which as you know changes cell contents when pressing F9.

Is there a way to have this happen constantly when the workbook is open & in use.

Using Excel ver 3.0

Any help greatly appeciated

Alley

 

[Andrew Poulsom]

The results will be updated each time the workbook is calculated. Isn't that sufficient? It would probably be quite often with calculation set to automatic.

 

[apearson]

Yes, I suppose you're right, but would have still liked to have known?

Thank you for your time & reply