AutoExpanding User Defined Function Output
 

Hi there

I have been trying to find a way to auto expand the output of
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 an
rows pertaining to the output.

From what I've seen it doesn't seem possible. What I wanted to do wa
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 littl
black boxes which can simply return a result. Excel would not allow m
to interact with the worksheet directly. I tried doing the same thin
through a sub procedure and it worked perfectly.

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

Can anyone tell me if this is possible?

Thanks a million
Mike Cav

--
Message posted from http://www.ExcelForum.com

AutoExpanding User Defined Function Output
 

Hi
see your replies in Excel.worksheet.functions
P.S.: please don't multipost

--
Regards
Frank Kabel
Frankfurt, Germany

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


---
Message posted from http://www.ExcelForum.com/