Random cell generator

[JK2]

I would like to set up a program that randomly selects a cell in a range of
eight cells.
Can anyone help?
--
Cheers
JK2

[Dana DeLouis]

>...randomly selects a cell in a range of
> eight cells.

Here's one idea. It randomly picks a cell from A1:A8. Adjust as necessary.

=OFFSET(A1,INT(RAND()*8),0)

--
HTH. :>)

Dana DeLouis
Windows XP, Office 2003


"JK2" <myname@discussions.microsoft.com> wrote in message
news:3C9CEA4C-B5AB-4A8B-8B9D-398E3CA0E9A1@microsoft.com...
>I would like to set up a program that randomly selects a cell in a range of
> eight cells.
> Can anyone help?
> --
> Cheers
> JK2