VBA Function not refresh

[tzcarmy]

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!

[Gary''s Student]

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
>
>

[tzcarmy]

Do you mean to add this line:

Application.Volatile

???

[Charles Williams]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[tzcarmy]

Thanx
I'll read it.

[Gary''s Student]

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
>
>