M
MikeCave
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
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