since you're not clearing the "G" cells, the formulas should still be there.
unless the user does something.
If I were you, I'd simply record a macro and insert the formulas.
then stop recording, and copy/paste the macro code  into your click
event after the clearcontents loop.