hi all
I would like to create multi cell array formula which will give random numbers totaling specified number. I have started, but I really don't know how to tell function that it's been entered on 6 or 10 cells.

Function RANDTOTAL(Total As Long, Bottom As Integer, Top As Integer) As Variant()

DON'T KNOW HOW TO START((((

End Function