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?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"windsurferLA" wrote in message . ..
| Custom Function to Retrieve Spread Sheet Data
|
| I am pretty sure that I have done the following successfully many years
| ago using my Excel97, but I can’t recall how.
|
| My workbook has two spreadsheets. The first [TaxOnSell] computes CASHOUT
| from PRICE and DOWNPAYMENT.
|
| In the second, I want to build a table showing the amount of CASHOUT as
| a function of various values for PRICE and DOWNPAYMENT.
|
| My though was to insert a custom function in the various cells of the
| second spreadsheet. The custom function would be of the form:
|
| Function CASHOUT(DOWN, PRICE)
| Worksheets("TaxOnSell").Range("E6").Value = PRICE
| Worksheets("TaxOnSell").Range("B43").Value = DOWN
| CASHOUT = Worksheets("TaxOnSell").Range("E58").Value
| End Function
|
| The function returns “#VALUE” , an indication I’m doing something wrong.
|
| Can I use a custom function in the above described manner, and if so,
| how do I get it to enter and retrieve the data?