View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
emsfeld[_4_] emsfeld[_4_] is offline
external usenet poster
 
Posts: 1
Default Randomize three variables subject to sum always equal to 1

Hi,

yes..I know that too. But I am quite new to VBA and have no real
overview of its functions yet. I can pretty much write very basic
applications. My problem is that I dont even know how to make Excel
find a random number through VBA. Not even to mention about making the
three random variables between 0 and 1 subject to the condition that
the sum of them has to be 1 any time three random numbers are
selected!

Thx anyways

Regards


---
Message posted from http://www.ExcelForum.com/