Array as output of function

[maca]

Hi, I wrote a VBA function which has an intput a column of length n. I do some calculations in my function and the output shoud be also o column of length n. Just that it did not function, even if I select the right area and click ctrl+shift+enter. It only registers the result of the first calculation n times.
How can I fix it?
Tks, Maca.

[Bob Phillips]

Show it and we can take a look.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"maca" <[email protected]> wrote in message
news:[email protected]...
>
> Hi, I wrote a VBA function which has an intput a column of length n. I
> do some calculations in my function and the output shoud be also o
> column of length n. Just that it did not function, even if I select the
> right area and click ctrl+shift+enter. It only registers the result of
> the first calculation n times.
> How can I fix it?
> Tks, Maca.
>
>
> --
> maca
> ------------------------------------------------------------------------
> maca's Profile:
http://www.excelforum.com/member.php...o&userid=24892
> View this thread: http://www.excelforum.com/showthread...hreadid=387105
>

[Alan Beban]

If you select a column for the output, select a row instead; and vice
versa. If that doesn't fix it, then as Bob Phillips suggested, post the
code.

Alan Beban

maca wrote:
> Hi, I wrote a VBA function which has an intput a column of length n. I
> do some calculations in my function and the output shoud be also o
> column of length n. Just that it did not function, even if I select the
> right area and click ctrl+shift+enter. It only registers the result of
> the first calculation n times.
> How can I fix it?
> Tks, Maca.
>
>

[maca]

Hi Alan,

Tks a lot. It was the application.transpose that helped after reading your comment.

Cheers,
Maca.

[Alan Beban]

maca wrote:
> Hi Alan,
>
> Tks a lot. It was the application.transpose that helped after reading
> your comment.
>
> Cheers,
> Maca.
>
>
Thanks for the feedback.

Alan Beban