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.