Hi,

Apparently there is n issue here. I am not aware of whats going on but it you remove "Call write3" the function works perfectly.

I am sorry I cannot help. One more question why is it that you want that code to be activated by a function? Why not use a Sheet_Calculate event if what you are looking for is the code to run every time the formula changes value.

Thanks