Select a random cell < 1
I'm not a programmer so I'm struggling with this.
I have a dynamic range of cells (say A1:A600, but will
expand beyond A600). These cells get individually
populated over time with a 1. I'd like a routine to
identify all cells in the range *without* a 1, and then
from this collection, choose a random cell (or row #,
since it's all in col. A).
Any sample code would be appreciated.
Thanks.
Jason
|