Need for Application.Volatile?
 

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/...indexvba.zip)?

Need for Application.Volatile?
 

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.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"Paul Lautman" wrote in message
...
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/...indexvba.zip)?

Need for Application.Volatile?
 

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

"Dick Kusleika" wrote in message
...
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.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"Paul Lautman" wrote in message
...
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/...indexvba.zip)?