At the top of the function add the line

Application.volatile
--
HTH...

Jim Thomlinson


"sybmathics" wrote:

Hi,

I creaed a function that chooses a random alphabetical character (from A to
Z), comparable to the built-in Rand function.
My function neither doesn't take any arguments.
One of the sympathetic uses of Rand or Randbetween is that it recalculates
automatically when pressing F9 or when pressing Enter or OK.
I would like to have that same kind of volatility to my RandCharacter
function.

Is this possible?

Anybody got any ideas?


Any help is greatly appreciated.


Sybolt