User Defined Functions Behaving Weird
Hi there,
I have been using the RiskSim user defined functions that utilizes the Excel
Rand function and it was working perfectly fine.
Recently I have noticed that it is starting to act in a very weird manner.
Whenever you start using the formula, it gives a #value error and then when
you copy and paste it again on the same cell or to other cells it works fine.
Has anybody came across a similar behavior of user defined functions beofre
- the issue seems very odd to me and I can not understand the rationale
behind it.
If somebody is really interested, I could send him the Add-in that I have
created and he can take a closer look at it.
Thanks and regards,
|