About Us

Alan Beban[_2_]

You're welcome; thanks for the feedback.

Alan

Jacob JKW wrote:
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.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
multiplying	wineforyou	Excel Worksheet Functions	5	November 15th 09 05:35 PM
Multiplying	Dave	Excel Worksheet Functions	1	November 28th 07 09:27 AM
Multiplying Contiguous Values in an Array	[email protected]	Excel Worksheet Functions	1	May 26th 07 06:46 AM
Array formula and multiplying conditions	KR	Excel Worksheet Functions	6	September 22nd 06 12:33 AM
Multiplying in a row	Daniel - Sydney	Excel Discussion (Misc queries)	3	September 27th 05 12:24 AM

Menu

About Us