Thanks for the reply. This code doesn't change the time when the formula returns a new result but I can change the Key Cells to the range where the data is entered and do it that way.