<div>
Thank you that is very useful. &nbsp; What did you use to find this?
</div>


Thank you that is very useful.   What did you use to find this?

<div>
ste5an: &nbsp; I just tried one of the functions listed. &nbsp;Do you know why the following gives me an error?:<br />
<br />
IsArrayAllocated
</div>


ste5an:   I just tried one of the functions listed.  Do you know why the following gives me an error?:

IsArrayAllocated

<div>
See <a href="http://www.cpearson.com/excel/isarrayallocated.aspx" rel="ugc">Is An Array Allocated?</a>.
</div>


See Is An Array Allocated? [http://www.cpearson.com/excel/isarrayallocated.aspx].

<div>
thanks -- I was able to get the function to compile when I added the huge number of functions your textbook referred to. &nbsp; But the program still fails on the Array Allocation test. <br />
<br />
Despite what you sent me - I think this is beyond my comprehension. &nbsp; &nbsp;All I care about is that the function accepts any set of cell range as an input. &nbsp; It doesn't at the moment until I understand more about what allocation means. &nbsp; &nbsp;I am not sure why this needs to be so complicated.
</div>


thanks -- I was able to get the function to compile when I added the huge number of functions your textbook referred to.   But the program still fails on the Array Allocation test.

Despite what you sent me - I think this is beyond my comprehension.    All I care about is that the function accepts any set of cell range as an input.   It doesn't at the moment until I understand more about what allocation means.    I am not sure why this needs to be so complicated.

<div>
<div class="content wysiwyg-content">
Would like a sample function that takes as its argument any array (one or two dimensions) and then gets its length (or if its two dimensional its length in both directions). &nbsp;Then allows me to do some sort of calculation on it and return that value (e.g. average, sum, max min).
</div>
</div>


Would like a sample function that takes as its argument any array (one or two dimensions) and then gets its length (or if its two dimensional its length in both directions).  Then allows me to do some sort of calculation on it and return that value (e.g. average, sum, max min).

VB function that accepts an array of unknown length

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.