dear sir ,
I have a custome function , it only works when i press F2 THEN ONLY .
I want it shold work like XLs default Functions
Example
10
10
=sum("a1:a2")
=mytotal("a1:a2")
When i change the value in a1 my function does not change the value .
if i press f2 it change
please help