View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Saarang84 Saarang84 is offline
external usenet poster
 
Posts: 1
Default How to choose Random rows??


Hi Rob,

I've checked out your code and it doesn't fix this requirement.

Out of the total number of rows filtered, say y, i need to choose x
rows *randomly* (where x<y). This x rows to be marked are stored in
-randRow-. The below line of code marks all the rows filtered. But i
need only x rows to be marked.


Sarang


--
Saarang84
------------------------------------------------------------------------
Saarang84's Profile: http://www.thecodecage.com/forumz/member.php?u=2386
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=207872

http://www.thecodecage.com/forumz


--- news://freenews.netfront.net/ - complaints: ---