Hi DM Unseen,

This won't help since, as I said, color change doesn't trigger any event
(incl. recalculation) so Application.Volatile will only fire out upon a real
change on sheet.

Regards,
KL


"DM Unseen" wrote in message
oups.com...
maybe the UDF this not contain the following line of code at the start
of the function

Application.Volatile True

DM Unseen