View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeff Wright[_2_] Jeff Wright[_2_] is offline
external usenet poster
 
Posts: 47
Default Simple Function question

Greetings!

I have a simple function, shown below:

Function Testing(X)
Dim Computed As Currency
Computed = (X + Range("A1"))
Testing = Computed
End Function

Let's say range A1 has a value of 10. Now, in my worksheet, I type into cell
B1:

=testing(5)

Cell B1 now correctly reflects the value of 15. However, if I change the
value of cell A1 from 10 to any other number, cell B1 will remain 15. Why
does the value of cell B1 not change? Conversely, I will obtain a correct
answer if I change the argument in cell B1.

Confused in Tucson,

Jeff