Forum Discussion
Save / Restore all formulas on a worksheet
The macro writes one formula in 10000 cells in this example. In cell I2 the formula =B2*C2 is entered, in cell I3 formula =B3*C3 and so on. If any changes are made in column I the formulas can be re-entered by running the macro. I wanted to show that the original formulas can be re-entered in almost no time with the help of a macro.
Can you share the formulas of your sheet? Maybe the formulas can be written into the file with the R1C1 code.
I solved something like that in a very unorthodox way. But this is probably only suitable for worksheets where there are not so many formulas. If you overwrite a formula with a value and later prefer to restore the formula.
I wrote the formula in the selection for the dropdown and did not restrict the values to those from the dropdown. You can also write your formula in the name editor and then only call up the name in the dropdown. This keeps the formula dynamic if you need it in several places in the worksheet.
I have made a very small example document. Maybe this will give you a useful idea outside of VBA. But the code is certainly great!