View Single Post
  #29   Report Post  
Posted to microsoft.public.excel.programming
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Randomly selecting a cell weighted on percentage

Ahh, think I've discovered why the occasional REF error kept popping up

I had used the data mentioned in your line to set it up on the sheet:
I had 40%, 10%, 30%, 10% ..

w/o realizing the percents don't add up to 100% <g
Once the above was corrected, there's no more REF error

But I'd still like to test run your sub abcd().
Grateful if you could clarify
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---