Not sure why your UDF doesn't update unless of course you've have
Calculation set to Manual (Tools Options Calculation).

Do you really need a UDF

=ROW(A1)+MATCH(MAX(A1:A9),A1:A9,0)-1

Regards,
Peter T

wrote in message
ups.com...
I thought this would be easy but I can simply not find anything in the
help system.

I have a vb function that finds the largest value amoung a range and
essentially spits out the row who has the largest number.

When I type in the =MyFunctionName(), I get the correct value in the
field.
BUT if I change/update any numbers in the data, the function does not
get automatically recalled, so the older now incorrect value remains.

All I can find to correct this is to click back in the cell, provide to
edit it, and click out and the function will refresh with the new
correct value.

Is there anyway for this to happen automatically, like a normal formula
in Excel would?