I have a user defined function (UDF) which sums visible cells from a predefined array. I have my sheet set to automatic recalculation, however I find that if i change any of the cells I still need to press F9 before the UDF will update itself.

Any ideas if there is a way round this ?
Thanks
Amy xx