Charles Williams wrote:
Well, you can add Application.Volatile to force the UDF to always be
recalculated, but thats horribly inefficient.

Whats wrong with using Ranges as inputs?

Charles

Thanks, Charles. I did just that. Making a volatile call is horribly
inefficient - sort of like bringing a rocket launcher to a knife fight.

I just rewrote the function so as to pass all the inputs as parameters,
got rid of the excess ranges that were reading values from various
sheets, etc.

I'm good to go.