10x Tom:)
My mistake... I my situation I put in column not into row:(
Into column situation right usage is {=TRANSPOSE(test())}
Thanks again

Tom Ogilvy wrote:
It works for me.

Select C4:E4, go to the formula bar and enter
=Test()
then exit with Ctrl+Shift+Enter

The 3 cells must be in a single row.

If displays 100 50 0

note that A(2) produces a 3 element array, same as Dim A(0 to 2)