JLGWhiz,

I did try using Private Sub Worksheet_Calculate() but ovbiously did not do something correct and am looking for help to solve.