View Single Post
  #19   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Pick Ref# randomly on an average

Well, if you had adjusted the eyeball alert N1's expression correctly -- as
highlighted in my earlier response, then one other possibility to try is to
simply to increase the param below in the sub (which Dave P gave to you in
your .programming query)

MaxCount = 1000

You could try increasing it to say:
MaxCount = 5000

Or, even:
MaxCount = 10000

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---
"Kashyap" wrote in message
...
If I increase the size of COL K,L,M to 20 and A,B,C to 40,
I'm not getting 'TRUE' in N1 at all ..