AutoExpanding User Defined Function Output

  • Thread starter Thread starter MikeCave
  • Start date Start date
M

MikeCave

Hi there

I have been trying to find a way to auto expand the output of a
function which returns a variable matrix result.

For example I want the user to be able to put a formula in one cell,
and then the function auto populates the correct number of columns and
rows pertaining to the output.

From what I've seen it doesn't seem possible. What I wanted to do was
simply:

In the function was the results have been obtained, right each row,
column entry to the correct cell manually.

The problem i ran into is that it seems VBA functions are like little
black boxes which can simply return a result. Excel would not allow me
to interact with the worksheet directly. I tried doing the same thing
through a sub procedure and it worked perfectly.

A sub procedure is not really an option as I want the user to be able
to go =<function name>(parameters) in a cell to invoke a function.

Can anyone tell me if this is possible?

Thanks a million
Mike Cave
 
Hi Mike

It is not possible to populate other cells via a Function. The only way
would be to arrat enter it into the needed range

*****Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum & Business Software*****
 
Thanks for the input. Well, if it can't be done it can't be done. Th
users will just have to learn to do it manually with ctrl shift enter.

p.s. Sorry for the multipost! New to this forum, but hope to make us
of it in the future, and I won't multipost again
 
IOt's not entirely clear that you can't do what you want with a
function. perhaps a small illustration would help us help you.

Alan Beban
 
Back
Top