You could experiment with putting that code in a Worksheet_Calculate() event instead.