spreadsheet as function

dbertenshaw

New Member
Joined
Apr 14, 2002
Messages
1
I have developed and spreadsheet of quite complex calculation using numerical approximation, and would like to use it as a function. I want to be able to call its calculation by passing a value or values to certain cells, then get back the computed values. I would then use this in another worksheet in multiple cells to perform analysis of other data already in that sheet.

In an ideal world, from sheet2 I would be be able to
CALL(sheet1!A1B2=C2B2, S4E4=sheet1!D3F4) where sheet1 contained the function calculation.

Since I want to embed this call in many multiple cells in sheet2, then a macro doesnt seem to be the right thing.

Any ideas??
This message was edited by dbertenshaw on 2002-04-15 07:13
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
You may want to try writing a UDF (User defined function) in VB to do this calc instead of referring to a set of calcs in another worksheet... not sure what to suggest without further info, but you can get some examples of UDFs from Aaron Blood's excel site

http://geocities.com/aaronblood/

might be able to help myself if I knew more about your complex calc...

Will
 
Upvote 0
Yeppers, and also create a named formula, works from sheet to sheet, or an actual add-in, works from book to book
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,113,999
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top