Hello Rocky2013,

There is a problem. VBA can not replace a value generated by a formula in a cell without deleting the formula in the cell. You will either have to commit to formulas or to VBA. You can not use both in this situation.