solving #Value error on User defined formula reading from different workbooks

Hi, this is the situation:
I have a macro that creates a number of rows and in some columns there are formulas that call userdefined formulas and external files to get results. When I execute the macro to create the rows there is no problem and even work with solver.

if at some point one of the external files is closed and a formula is edited (with no actual change) the formula returns "#Value!"
to sove that I can reopen the file and by going to edit-->replace "=" by "=" all gets recalculated and correct results are returned. (normal recalculate --F9-- does not work, but I can live with that)

up until here is quite understandable.

HOWEVER:

I recorded a macro to do it exactly programatically and it does not work
any clues on the reason / possible workaround??

Please Login or Register  to view this content.

and this is the user defined function:

Please Login or Register  to view this content.

and other formulas contained

Please Login or Register  to view this content.

you need to make your udfs volatile or pass them all the ranges they require as arguments so that they recalculate automatically. then you shouldn't need to bother replacing = with =