Hello

I am looking for a relatively safe and stable way for a user defined
function to return some data outside of the cell that called it.
Basically I have in cell A1 a function "=MyFunc()" and I would like it
to return in the cells:
A1: "Row 1 txt"
A2: "Row 2 txt"
A3: "Row 3 txt"

the simple way to do that is to create a user defined function that
returns an array and to use the array formula {=MyFunc()} in range
A1:A3. But is there a way for a function that only sits in cell A1 to
return values in range A2 and A3?

One of the things I am a bit concerned is if I start putting in the
code for MyFunc some access to range A2 and A3, I am going to mess
with the calculation order of excel, i.e. excel didn't expect the
cells A2 and A3 to be affected by the calculation of the cell A1
(since they are originally empty cells). Would that be a source of
unstability?

If you've already tried to doing that, I would be interested in your
feedback

Thanks
Charles