Need for Application.Volatile?

[Paul Lautman]

As I understand it, a UDF will recalculate if any of the input variables
change.

That being the case and since all the used variables are in the input
parameters, is there any need for the Application.Volatile entries in the
XINDEXvba samples on the byg site
(http://www.bygsoftware.com/examples/zipfiles/xindexvba.zip)?

 

[Dick Kusleika]

Paul

I don't see any need for them. Some people include it 100% of the time
(which is bad practice), so that may be the case here.

Just to be sure, I downlaoded it, removed the Volatile statement and tried
to break the formula. I couldn't do it. I just don't think it's necessary
here.

 

[Paul Lautman]

Thanks, that was my opinion too. I'm glad for the reassurance, it means that
I do understand it!