View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jason Morin[_3_] Jason Morin[_3_] is offline
external usenet poster
 
Posts: 18
Default 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