Forum Discussion
KevinAP
Dec 20, 2021Copper Contributor
Re-enter a formula after deleting cell data in a column of cells
How do I write the macro to re-insert a formula after cells in the range have been overwritten and then cleared? What I have so far is: Sub Macro1() ' ' Macro1 Macro ' If Range("C15").Value ...
KevinAP
Dec 20, 2021Copper Contributor
Thanks,
Still having trouble. Does this information go in the sheet code or the module code?
HansVogelaar
Dec 20, 2021MVP
It is an ordinary macro, so it should be copied into a standard module, not into a worksheet module.