S

#### snv

similar to any other pre defined funtion.

For example, let my array be

{1;4;9;16;25;36}

If I select a 6x1 range of cells and enter the formula

=SQRT({1;4;9;16;25;36})

with a ctrl+shift+enter

I get

1

2

3

4

5

6

Now I want to write a UDF that does the same thing

Function myUDF(Input As Variant) As Variant

myUDF = Input ^ 0.5

End Function

when I enter

=myUDF({1;4;9;16;25;36})

again, with ctrl+shift+enter

I get

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

Interestingly enough when I enter

=myUDF(81)

I get

9

Had myUDF been

Function myUDF(Input As Variant) As Variant

myUDF = Input

End Function

IE, no modification, just return what I get

=myUDF({1;4;9;16;25;36})

returns

1

4

9

16

25

36

as expected.

The problem seems to be when I try to use myUDF in an array context

and I try to modify the input in any way. How can I get it to act

just like the

=SQRT({1;4;9;16;25;36})

And before anyone asks why I trying to emulate an already existing

function, this is just an example to illustrate the problem.

Please help and thanks in advance

Sean