I'm talking nonsense, sorry. All I need is for the macro to automatically revert specific cells to their formulas, and I can do that using some of the code above. Sorry for the pointless thread!