On Jan 4, 12:44 pm, Alan Beban wrote:
Or, if the functions in the freely downloadable file at http://home.pacbell.net/bebanare available to your workbook,
Public Function MyReturnArrayFunction(iScalar As Single) As Variant()
On Local Error GoTo ErrHandler
Dim myRawProbs() As Variant
myRawProbs = Array(19, 38, 57)
MyReturnArrayFunction = _
ScalarMult(Application.Transpose(myRawProbs), iScalar, False)
Exit Function
ErrHandler:
Debug.Print Err.Description & " (" & Err.Number & ")"
End Function
called as
=MyReturnArrayFunction(19)
will do so.
Alan Beban
I haven't tried your suggestion yet, but there does look to be some
pretty cool functions in your spreadsheet Thanks much for the link,
Alan.