refresh function

M

masterphilch

Hi

I wrote a function, which is accessed via cell. ('=functionname(args)').
As I change arguments, involved in the function, it processes. In an
other cell, there's the same call to the function. When I now change the
args of the first cell, the second doesn't update - but should, as if
I'd press 'F9'. How can I force a refresh through code?

thanks for help
masterphilch
 
B

Bob Phillips

Why do you need the second to change when the arguments to the first are
changed? If you must, you could try adding

Application.Volatile

at the start of the function.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
M

masterphilch

Because i've got a list with groups and scores of each group. i want to
find out which one is heading. i could enter all the stuff, then sort
the table and write manually which one is first, second and so on... but
it's sort of challenge and fun to do it with code.
and because the rank depends on the score of the others, every cell has
to be updated... got it?
 
N

Niek Otten

Are all of the inputs in the argument list?
If you use a cell directly from within a function, Excel doesn't know when
to recalc.
Why not post your code and the values of the precedent cells?
 
M

masterphilch

oops!
So I'm very sorry... Never thought that 'got it' is that rude (or what).
I'm not a professional english-writer... But I try to learn by doing!
 
Top