The statement help to insure the function will be called. Sometimes Excel
thinks its really smart and avoids calling a function if it thinks the
argument has not changed.
--
Gary''s Student - gsnu2007d


"Ray" wrote:

Perfect, Gary ... UDF and conditional formatting worked exactly as I'd
hoped!

one question: what does 'Application.Volatile' mean? why is it
necessary?

thanks,
ray