Is there a formula that can pattern match?
Hi,
I would only suggest that Application.Volatile be added to the code, like
this:
Very bad habit: Adding Volatile to function only make your model slower (always
recalculating even if the dependent cell have NOT changed) .
Make sure you add the dependent cell in your function's arguments and the
recalcs will occur appropriately.
Regards,
Daniel M.
|