Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Simple Sum function question | Excel Worksheet Functions | |||
Probably simple question on AVG function | Excel Discussion (Misc queries) | |||
Simple Function question? | Excel Worksheet Functions | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) |