Function/Sub to put in neighboring cells array output

[Chondrulos]

Dear all,

I have a function that returns a 7x2 array.
I would like to have this array fully displayed in the neighboring cells.

I'm aware of the combo Formula+SelectRange+F2+Ctrl-Shift-Enter, but afterwards this doesn't allow me to modify seperately each cell ('You can't change part of an array').
Also, it's really tedious to 'explore' the array with the INDEX function.

I'm aware of the rule, that a UDF cannot modify cells outside the calling cell. So the solution could be calling a Sub routine.
Something like that:

Please Login or Register  to view this content.

With something like that in the function:

Please Login or Register  to view this content.

But something is bogus somewhere, and I cannot figure why.

Thanks for your help!

[xlnitwit]

Hi,

Getting the function to call a subroutine will not work- it does not bypass the limitation on what a UDF is allowed to do. It is possible to workaround these limitations using timers or other events in combination with static variables but honestly it is easier to simply use INDEX if you don't want to array enter the formula.

[Chondrulos]

Hi,

Thanks for your reply.
It's what I thought. Then, a simple Macro should do the trick to quickly 'INDEX' everything.

Cheers