i tought that by using :
[VBA]
application.volatile
[/VBA]
i will not have to use F9 to update my sheet after using my function.it did not happen .why?
thanks