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 am not clear on what that macro is doing, could you explain?
Also, here is a screenshot of my worksheet, every cell visible starts with a formula in it, until the user overwrites it with changes.
Edit: OK, i see, your writing one formula to one cell correct?
unfortunately i am dealing with hundreds of cells (in the image above, this thing extends to the right for quite a ways) and the formulas are different in each cell.
I was hoping for an automated way to copy all the formulas and store them to be reapplied later with a macro.
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 need to restore my data on in My " C" column of my worksheet ..how do I do that ?
