What are volatile functions and why would I want to activate them in the code below?
Please Login or Register to view this content.
What are volatile functions and why would I want to activate them in the code below?
Please Login or Register to view this content.
That function is passed everything it needs to calculate a result, so there is no need to make it volatile, and doing so will just slow the workbook down.
Entia non sunt multiplicanda sine necessitate
You might find this interesting: http://www.decisionmodels.com/calcsecretsi.htm
IMO, making a UDF volatile is a "band-aid" covering the programmer who did not want to code the UDF correctly. As shg points out, this UDF seems well coded and does not need to be volatile.
Originally Posted by shg
1 sum(--(match(A1:A15,A1:A15,)=row(A1:A15))) as CSE returns the same
2 the code is not so good. it would be much better at first do: range=array
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks