thebaje wrote:
Your code snippet works when the array is called within a Sub. I have seen
and tried code snippets from other posts using the same approach you
outlined,but have never been able to get it to work as a worksheet function
call. If the function is used in a cell on an Excel worksheet and the array
values are called from a range on a worksheet, the result is the #VALUE error
message

For example, the values 1,2,3 are in Rows C3:C5 and named ArrIn. When
=DoNothing(ArrIn) or DoNothing(ArrIn()) is entered in Cell D7 , the result is
always #VALUE! .

The above is simply wrong. Perhaps there is something in your code for
DoNothing that causes it. With 1,2,3 in C3:C5, which is named "ArrIn", with
Function DoNothing(whatever) As Integer
DoNothing = Application.Sum(whatever)
End Function

then on the worksheet =DoNothing(ArrIn) returns 6

Alan Beban

Am I missing something?

thebaje