Custom Function to Retrieve Spread Sheet Data
The values of the arguments were non-integer numbers
If one can’t change anything in the first spreadsheet from with a
function in the second spread sheet, then my approach will not work.
I’m not sure how I did it in the past; perhaps I had written a macro
that cycled through all the cells in the second spread sheet, plugging
in and retrieving data from the first spreadsheet.
An approach to my problem may be to use Excel’s Scenario manager to
summarize the results from various combinations of inputs.
Niek Otten wrote:
You cannot change anything in a worksheet from within a function.
You should include all input to the function (like E58) in the argument list and not address cells directly.
What were the values of the arguments and the cells involved?
|