functions only update if their parameters change: neither of the two
parameters in your function refer to A1 or A2, so the function will not
update.

regards
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm

"Marcin Zmyslowski" wrote in message
...
I have created a VB function which look like this:
public function function_1 (parameter1 as string, parameter2 as integer)
as
string

my form look like this:
A B
1 5 =function_1("03.2004";row())
2 10 =function_1("03.2004";row())

I noticed that when I change the values from cells: A1 and A2, the
function
(function_1)
isn`t updated automatically, that`s why this value returned by this
function, is now older/previous
one. How to refresh the value returned by this function automatically
after
changing cells A1, A2??

Any help appreciated
Thankx
Best regards
Marcin