VBA Function not refresh
 

Hi
I have an Excel file with VBA function
The problem is after a while of working with this file, the VB
function "get tired" , that mean they not refresh or return zero o
value instead of valid number.
some pepole told me it's becouse the RAM memory is full (even it's nic
strong PC).
Does someone know how to Handle this problem ? (F9 doesn't help)
Is there any way to clear the memory that those Function take ?

Thank's for any help

--
tzcarm
-----------------------------------------------------------------------
tzcarmy's Profile: http://www.excelforum.com/member.php...nfo&userid=923
View this thread: http://www.excelforum.com/showthread.php?threadid=52802

VBA Function not refresh
 

Make sure that the argument list in the function header allows Excel to
recognize when the function should be re-evaluated.
--
Gary's Student


"tzcarmy" wrote:


Hi
I have an Excel file with VBA function
The problem is after a while of working with this file, the VBA
function "get tired" , that mean they not refresh or return zero or
value instead of valid number.
some pepole told me it's becouse the RAM memory is full (even it's nice
strong PC).
Does someone know how to Handle this problem ? (F9 doesn't help)
Is there any way to clear the memory that those Function take ?

Thank's for any help!


--
tzcarmy
------------------------------------------------------------------------
tzcarmy's Profile: http://www.excelforum.com/member.php...fo&userid=9232
View this thread: http://www.excelforum.com/showthread...hreadid=528022

VBA Function not refresh
 

Do you mean to add this line:

Application.Volatile

???


--
tzcarmy
------------------------------------------------------------------------
tzcarmy's Profile: http://www.excelforum.com/member.php...fo&userid=9232
View this thread: http://www.excelforum.com/showthread...hreadid=528022

VBA Function not refresh
 

see http://www.decisionModels.com/calcsecretsj.htm for an explanation and
examples.

Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com

"tzcarmy" wrote in
message ...

Do you mean to add this line:

Application.Volatile

???


--
tzcarmy
------------------------------------------------------------------------
tzcarmy's Profile:
http://www.excelforum.com/member.php...fo&userid=9232
View this thread: http://www.excelforum.com/showthread...hreadid=528022

VBA Function not refresh
 

Thanx
I'll read it.


--
tzcarmy
------------------------------------------------------------------------
tzcarmy's Profile: http://www.excelforum.com/member.php...fo&userid=9232
View this thread: http://www.excelforum.com/showthread...hreadid=528022

VBA Function not refresh
 

Suppose you wanted a function that returned the value in A1 doubled. There
are two ways to code this:

function bump(r as range)
bump=(r.value)*2
end function

and

function bump()
bump=(range("A1").value)*2
end function

put 10 in A1 and either code will return 20. However if you change A1 only
the first code will respond to the change.
--
Gary''s Student


"tzcarmy" wrote:


Thanx
I'll read it.


--
tzcarmy
------------------------------------------------------------------------
tzcarmy's Profile: http://www.excelforum.com/member.php...fo&userid=9232
View this thread: http://www.excelforum.com/showthread...hreadid=528022